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

[Closed]
Report
Posts
1
Registration date
Sunday December 1, 2013
Status
Member
Last seen
December 1, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
is there any logic in this
C6 B8 B5 D6 D8 D6 F8 G8 C6 B9 B5 E9 F9 G9
or are they random