Formula to go into sub folders of main folder and get values from

B

BadBoy

I was hoping to have a formula similar to the one I have posted. This way it
can go into the main folder, look through all other folders, find all report
cards, and sum the value at the address so that I can have a grand total
carried to my data base.

Is this possible?

Test 1 through 3 are folders all containing 1 file called 'report card'.

Although called Test, these folders are actually different peoples names.

=SUM('C:\NORTH BAY TIMMINS\TEST1,TEST2,TEST3\[REPORTCARD.XLS]Report
Card'!$D$14)

I wish to have a formula that will go into all the sub folders within a main
folder and look for the file called 'Report card' and then sum the values
from the above cell.

Any help would really be appreciated.

-Bad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading Multiple Files 5
using an IF or AND function to get next largest value in list 1
Making a sub run in a particular folder 1
Messages from user folders disapper upon deletion (do not go to the Deleted Items folder) 5
Why do some .ics go into Events Calendar not my main one? 1
Search and consolidate multiple values in multiple fields 2
Vlookup multiple criteria multiple occurrences sum values 0
VBA to copy messages from folders & subfolders to single folder 1

Top