T
TBarnes
I need to summarize identical worksheets from approximately 50
workbooks. Auditors in my company visit Field Offices and creat
workbooks for each case (approximately 500) they review. Each workboo
has two detail worksheets and one summary worksheet. I've been asked i
I can create one grand total worksheet that summarizes the values in th
summary worksheets across the 500 workbooks.
I've read about links, but need a better way. Building the dependen
formulas by opening each source workbook is impractical given th
volume. I also wonder if the dependent formula can be that big?
All of the workbooks will reside in one folder on a file server.
I need to be able to calculate the grand totals on demand. The numbe
of workbooks in the folder may vary over time.
I've done some solutions using VBA, so I'm willing to try anything
workbooks. Auditors in my company visit Field Offices and creat
workbooks for each case (approximately 500) they review. Each workboo
has two detail worksheets and one summary worksheet. I've been asked i
I can create one grand total worksheet that summarizes the values in th
summary worksheets across the 500 workbooks.
I've read about links, but need a better way. Building the dependen
formulas by opening each source workbook is impractical given th
volume. I also wonder if the dependent formula can be that big?
All of the workbooks will reside in one folder on a file server.
I need to be able to calculate the grand totals on demand. The numbe
of workbooks in the folder may vary over time.
I've done some solutions using VBA, so I'm willing to try anything