macros for linking multiple workbooks to one workbook
Linking into multiple workbooks slows opening a workbook. It is better to
just put the daily totals into the workbook. I need more information to help
write a macro
1) The names of the 31 worksheets
2) The source and destination locations of the data.
3) the worksheet name(s) in the monhthly total workbook
"dac803" wrote:
I have a workbook for each team with 31 worksheets in each workbook for each
day of the month. These workbooks are linked to a monthly workbook with a
row for each team. I am looking for a macro to run that will link daily
totals for each day into the monthly workbook. I hope this is clear.
--
dacbam
|