• 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.

Macro to combine data from various Workbooks

U

Uma

New Member
Hi,


I need help to write a macro to achieve the following scenario:


(a) Jan2011.xlsx has Expense details for 4 members for the month of Jan 2011


https://docs.google.com/open?id=0BzkTJyBjnBLRb0prQ0lkYmlIS2s


(b) Feb2011.xlsx has Expense details for the same 4 members for the month of Feb 2011


https://docs.google.com/open?id=0BzkTJyBjnBLRamVDUzY1QUNFWlU


(c) The resultant workbook (similar to 2011Expenses.xlsx) to be generated with worksheets for each member combining the Jan & Feb month data from the Jan2011 & Feb2011 workbooks.


https://docs.google.com/open?id=0BzkTJyBjnBLRdjRSd1NaNkF5ZFU


Regards,

Uma
 
Check out some of Ron's merge/copy macros on this page:

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


(scroll about halfway down to "Copy/Paste/Merge" section)
 
You must log in or register to reply here.
Back
Top