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 December 1, 2013 Status Member Last seen December 1, 2013 - Dec 1, 2013 at 01:20 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 2, 2013 at 10:45 PM
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

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