Thread: Macro opens some MS workbooks, takes specific data in Master Workbook, then closes.

Hi all,

I am making a project where every business day I need to make a new workbook (by pressing F12 key), and I copy the summary (or specific cell) data, then paste in the Monthly Master workbook's sheet in the same order. We save workbooks on dates name.

for more detalis:
We have a particular MS workbook, which contains 5 worksheets +1 summary data worksheet, and it is shared for the team. The summary worksheet is protected by us, tells abt the counting and total. Every day we make a copy of this workbook in a folder (for example - all the workbooks on business days of the month of August will keep in the folder - "August 2010" at a specific location at shared point). This is a daily activity for every month.

We need all the summary sheets data for the Master workbook to display & check all the summary details as per day at the same time (on a single worksheet), then we have to collate the data, and get the final summary of it on another worksheet, which is the final monthly result with ranking of the team members.

I have heard & saw tht macro can do this easily, and Macro can open all the MS workbooks, take or pull the specific data, then paste in the Master Workbook, then close that workbook. Macro will do all the actions one by one for all the workbooks of the monthly folder.

You guys plz assist me on this, providing me links & videos for it, will be much appreciated.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Thanks for replying!
okay... I'll give u after a few hours. Do I need to make all the workbooks of all the business dayz with a master workbook of data collation? or just a few workbooks with a master workbook is okay here??

Just supply a sample that reflects your question......