Need to add the same cell from several workbooks

G

Guest

I have several workbooks which are identical, but have different file names.
I need to add the same cell from the same worksheet in these different
workbooks into another worksheet to get a total for the entire workgroup.
Each workbook has a worksheet titled "Total Score", which has 2 values (in c2
and c4) that I need to add into a separate workbook. Is there a formula I can
use to do this, rather than opening each workbook and clicking on the cell
while I am in the formula bar?
 
G

Guest

Solved the problem. I ended up needing more information than just the two
cells, so I linked each workbook into a new one and then just did a sum.
 

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

Top