• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copying data from multiple workbooks

N

nfowler30

New Member
Hi

I have a sales forecast workbook for each of 6 account managers. The headings are the same for each workbook.

I want to basically copy all of this data into a master workbook as an exact replica so I can then filter the data.

I could just copy and paste special (as the individual sheets have lookups depending on data entry) but would prefer to be able to do this more automated - please help!
 
Check out Ron's section on Copy/Paste/Merge here:

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


He has several good articles about creating summary workbooks form multiple files.
 
You must log in or register to reply here.
Back
Top