Finding external Excel files and crating a dashboard.
 

Problem:

I have a folder where Excel files(.xls) are frequently being added and
updated. I need to build a "dashboard" type Excel file that can:

1) look in this folder
2) find any Excel files
3) take a totals row from these files
4) add the totals rows in a single row on the Excel file I am creating.


--
trumb1mj
------------------------------------------------------------------------
trumb1mj's Profile: http://www.excelforum.com/member.php...o&userid=34847
View this thread: http://www.excelforum.com/showthread...hreadid=545924

Finding external Excel files and crating a dashboard.
 

It would be worth recording this sequence to get m ost of the necessary
code. Then you can amend this with a section which uses the
DIR(Path*.xls) statement to get the list of files. Then just loop the
macro around.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=545924