How to Copy my all data in excel sheet1 to sheet 2 [Closed]

Report
Posts
1
Registration date
Wednesday October 29, 2014
Status
Member
Last seen
October 29, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
HI.. all

I have a Question. I have some data in my excel sheet1 . i want same data move or copy sheet1 to sheet2 by formula.

i wait response.



Thanks

Chandan Kumar Pandey

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
open sheet1
select a cell
control+A
control c
goto sheet 2
select A1
control V

if you want macro

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!