Adding values in different workbooks

  • Thread starter Thread starter joeldsmt
  • Start date Start date
J

joeldsmt

I currently keep track of sales through a detailed spreadsheet ever
month. I make a new workbook each month only used the older books fo
reference. Each workbook has a sheet that has all of the sales detail
needed for productivity reports.

I am trying to make a year to date workbook that is totally separat
from all of these months. What i am getting stuck on is, that i wan
to keep this simple and only have one sheet on this book, which add
specific cell value on a sheet to the matching cell value on another.


Example. WORKBOOK1 SHEET 1 CELL C5 must be added to
WORKBOOK2 SHEET1 CELL C5 and
WORKBOOK3 SHEET1 CELL C5 etc...
these values need to be placed on
WORKBOOK13 SHEET1 CELL C5

Sheet 13 looks exactly like all the other sheets but it has the adde
values of the same cells in each of the previous sheets.

I have tried doing it through the ABS and SUM functions but they wil
only let me add 5 months.

I dont know if it is because the string is too long or if i am doin
something wrong.

Please let me know if anyone can help. I am just out of ideas
 
Have a look at Data / Consolidation. There is quite a bit of explanation in the help, and then if you need any specific help, I'll be glad to help.
 
Back
Top