How to capture the data with using of Macro

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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
"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