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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
"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")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!