Additional Info

Share

  • Hot Topics

Excel Copy and Paste to next empty row

Hi All, I have a excel sheet with two tabs and want to be able to copy and paste data between the two tabs in the following scenario. Tab 1 - User has entered numbers on following cells A1 C1 E1 H1 A2 C2 E2 H2 A3 C3 E3 H3 User presses a but which contains macro which copies the data from Cells as above and pastes them into Tab 2 on the following cells A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 Process is repeated again in Tab 1 but cells are now copied to A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 Process is repeated again in Tab 1 but cells are now copied to A3 B3 C3 D3 E3 F3 G3 H3 I3 J3 K3 L3 And so on. Is this possible at all? Regards

This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of January 30, 2018.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel