How Can copy whole data from excel 07 sheets

Closed
waseem - Mar 16, 2010 at 06:56 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 16, 2010 at 10:04 AM
Hello,
I am using MS Office 2007. Please let me know that how can I copy whole data from sheet one to sheet two. I want to copy the whole data from row 5 to onward in sheet two. The whole scenrio is given below in detail.

Sheet one:
Copy the data from column B and Row 3

Sheet Two:
Paste the Copied Data in Column B and Row 3

Sheet One:
Copy the whole data from Column B to Column G and Row 5 to onward

Sheet Two:
Paste whole copied data in sheet two from last filled row to onward

Data dont overwrite on any row or column. Every data will be add in sheet two from sheet one when macro will be run.


Thanks

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 16, 2010 at 10:04 AM
Use macro recorder and record your actions. This will give you a template. Then you can modify the code to suit your need.
0