Macro

  • Thread starter Thread starter massa
  • Start date Start date
M

massa

Can you create a macro from multiple files in a directory? If so how do I
begin.
I have a workbook that I update with new data each week from multiple
sheets. I would like to automate this process, can someone help? Thanks.
Amy
 
Why not use formulas to update the master workbook form all the subordinate
workbooks? Just open all the workbooks you need to link to and in the
workbook where you enter the updates move to the cell the update is to appear
in and type and equal sign to start the formula. Press Ctrl + F6 to cycle
through you open Excel workbooks and click on the cell you want to link to
once you get to the correct workbook.

The formula will look similar to the following:

='[AdditionFunctions.xls]January 05'!$I$35

='[WorkbookName.xls]Sheet Name'!CellAddress
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros 3
Excel shortcut options 0
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Macro 3
Moving certain data to different sheet 1
Macro to copy value in field and insert it into filter 2
Macro Help 2
Macros to extract data frommultiple workbooks to a master workbook 0

Back
Top