Macro
 

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

Macro
 

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
--
Kevin Backmann


"massa" wrote:

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