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

Use a master workbook to carry over changes to multiple workbooks 1
Dumb question alert! What program to use? 0
Generated text copies into another template 0
Formula for adding a cell in multiple workbooks 3
Unwanted workbooks on startup 2
Consolidation Table from Different Excel Tabs with Different Format 1
Copy cells in Excel 1
VBA concatenate ranges into a new document 0

Top