How do I get a macro to move between workbooks?
I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4,...
View Answer
| Jun 19 2008 1:19 AM GMT
| asked by
Bondsmith
Macros, Microsoft Excel, Workbooks
One Cell to calc inputs from mult workbooks
Have a summary sheet and want it to calculate information from a standard daily form (seperate workbook) that gets saved as the days date, daily. Want summary sheet cell to continuously calc what is inputed on daily form even after it is saved as something else.
Answer Question
| Feb 13 2008 6:10 PM GMT
| asked by
BEBGMH
Workbooks, Microsoft Office, Microsoft Excel
