How to Copy my all data in excel sheet1 to sheet 2

Closed
c.pnadey6 Posts 1 Registration date Wednesday October 29, 2014 Status Member Last seen October 29, 2014 - Oct 29, 2014 at 09:14 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 30, 2014 at 03:53 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Oct 30, 2014 at 03:53 AM
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")
0