View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
trumb1mj
 
Posts: n/a
Default 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