Adding like cells from different workbooks

M

Mr B

I have 12 workbooks that i want to total into another workbook. All the
workbooks are alike and formated the same. I have gone to each workbook and
copied the cell and pasted it into the new workbook, that worked. But i want
to get the rest of the info without haveing to go back to each sheet or by
changing the formula. HELP
 

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

Formula for adding a cell in multiple workbooks 3
Excel 2007 - Linking workbooks 1
Serious Excel Challenge 0
How do I merge/combine different workbooks with different sheets 2
Adding data from different workbooks 3
Copying Worksheets From Different Workbooks using Marco 4
adding totals on different pages in different workbooks 1
Combine date from multiple Workbooks into one worksheet 2

Top