Appending Data
 

I have a several worksheets with data that needs to be combined into one main
worksheet. Right now I copy the information from each one and keep adding it
the bottom of the main list. It isnt hard to do but some of the workbooks
have a lot of worksheets and I am just looking for a quick way to handle
this. I have looked at the consolidate feature and it would not work for
what I am trying to do.

Any help will be appreciated.

Jordan

Appending Data
 

Refer the below link by Ron on copying from row 2 till the last row with data

http://www.rondebruin.nl/copy2.htm

If this post helps click Yes
---------------
Jacob Skaria


"Jordan" wrote:

I have a several worksheets with data that needs to be combined into one main
worksheet. Right now I copy the information from each one and keep adding it
the bottom of the main list. It isnt hard to do but some of the workbooks
have a lot of worksheets and I am just looking for a quick way to handle
this. I have looked at the consolidate feature and it would not work for
what I am trying to do.

Any help will be appreciated.

Jordan