Need help with a summary worksheet

[Troy Green]

Hey guys, I've done a few searches and found some info. regarding what I want to do, but can't make it work for my situation.

I have a Folder full of workbooks, these are estimates for customers, and as such the spreadsheet workbooks file names are Cusomers name, eg. Mike Smith.xls, Troy Green.xls, etc.

I have a sheet in these workbooks named "Invoice", I need to have a seperate workbook that totals cell "Invoice E25"

Any help is appreciated......

Thanks,

 

[Tazguy37]

All those workbook you want to add data from aren't open are they?

If they are, it's a lot easier.

If not, some VBA code could be written to open each of those files and add those values together, and paste the result (as a value) to the resulting workbook.

There's other ways to do this, but that's one. Let us know if the workbook are open/closed (are they all in the same folder? I think you said that.)

 

[Troy Green]

Tazguy,

I don't mind opening all the workbooks if it will make this easier. I will just do this once a week which should only mean 30 to 50 workbooks.

I'm not even sure what VBA stands for so I probably don't want to get involved in that

Yes all these workbooks are in one folder "Bids".

Thanks in advance for any help.

 

[Tazguy37]

I had to enter the formula like this:

=[Book3]Sheet1!$A$1+[Book4]Sheet1!$A$1+[Book5]Sheet1!$A$1+[Book6]Sheet1!$A$1

I just typed = and navigated to each cell I wanted to add, entering a plus in between. Kind of a pain in the butt if you have a lot of workbooks. I've seen this done differently, usually requiring VBA code, though.

Hope that helps!