How to capture the data with using of Macro

Closed
Lokipush Posts 1 Registration date Wednesday September 25, 2013 Status Member Last seen September 25, 2013 - Sep 25, 2013 at 06:13 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 26, 2013 at 02:46 AM
Hi,

Am crating a excel form in sheet#1 as following entry's.

Row Column
A B C D E
1 GR-1 15 20 30 60
2 GR-1 10 5 20 10
3 GR-1 5 10 10 5

How to capture this data as such same as copy to Sheet#2 using with macro?

Thanks in advance!

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 26, 2013 at 02:46 AM
"How to capture this data "
what is meant by this?. do you want to copy the whole data to sheet2

if this is so code will be

worksheets("sheet1").cells.copy worksheets("sheet2").range("A1")
0