Previous Topic Next Topic

Copy worksheet misc data in sheet 1 to new row in Master Sheet 2

Closed
GJosephM Posts 1 Registration date Sunday 1 December 2013 Status Member Last seen 1 December 2013 - 1 Dec 2013 à 13:20
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 2 Dec 2013 à 22:45
Hi,
I'm a complete newbie to Excel macros..

Sheet 1:
Sheet 1 is my work sheet where i manipulate data.
Upon completion of fine tuning the data, I'd like to hit a macro button to capture the data in the following cells located in Sheet 1: C6 B8 B5 D6 D8 D6 F8 G8 C6 B9 B5 E9 F9 G9 and then transfer the data to Sheet 2 starting with colum/row C8.

Every time i hit the macro button, I'd like the new data in sheet 1 to be transferred to sheet 2 in the next row..

Thank you for your assistance!!

Joe
Related:

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
2 Dec 2013 à 22:45
is there any logic in this
C6 B8 B5 D6 D8 D6 F8 G8 C6 B9 B5 E9 F9 G9
or are they random

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses