Thank you for your reply :P
"Ashish Mathur" wrote:
Hi,
Try the RDB Merge Addin - http://www.rondebruin.nl/merge.htm
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"BadBoy" wrote in message
...
Good Morning,
I have a data base titled 'DISTRICT YEARLY ROLL-UP'.
This data base looks in a folder called 'NORTH BAY TIMMINS' for the name
'MARTIN114' and looks inside this folder for a file called
'REPORTCARD.XLS'
and finally reads a file called JAN at the location provided below.
=SUM('C:\NORTH BAY TIMMINS\MARTIN114\[REPORTCARD.XLS]JAN'!$D$14)
My question is the following;
There are more names than just 'MARTIN114' in the folder and I wanted to
be
able to have my data base read the report card of all names at that
location
(JAN'!$D$14)
Is there a way to tell my data base to read the values at JAN'!$D$14 from
all REPORTCARD.XLS from all folders within the 'NORTH BAY TIMMINS' folder?
Thank you in advance :P
-Bad