J
Juan Sanchez
What does the names of the 100 workbooks looks like, is it
a constant name with minor variations? Can you give some
more information like which 3 cells do you need?... would
you be interested in a macro solution or would prefer just
formulae...
More info... more help.... cheers
Juan
Workbooks, I would like to take the data from 3 cells. And
on my summary workbook/sheet, have Excel automatically
pull that data from all 100 workbooks/sheets, add the 3
cells, and give me a combined grand total.
2nd workbook/sheet into that same cell, I get a value
error.
a constant name with minor variations? Can you give some
more information like which 3 cells do you need?... would
you be interested in a macro solution or would prefer just
formulae...
More info... more help.... cheers
Juan
of data from 100 other Workbooks. From each of the 100
Workbooks, I would like to take the data from 3 cells. And
on my summary workbook/sheet, have Excel automatically
pull that data from all 100 workbooks/sheets, add the 3
cells, and give me a combined grand total.
into the summary workbook/sheet. BUT when I try to add a
2nd workbook/sheet into that same cell, I get a value
error.
automatically update itself when it opens.