Finding external Excel files and crating a dashboard.

Giganews Newsgroups
Subject: Finding external Excel files and crating a dashboard.
Posted by:  trumb1mj (trumb1mj.28fa6y_1148660100.6464@excelforum-nospam.com)
Date: Fri, 26 May 2006

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?action=getinfo&userid=34847
View this thread:http://www.excelforum.com/showthread.php?threadid=545924

Replies