automatically move cell data in 1 workbook to another workbook

G

Guest

I have several workbooks with similar cell information containing totals. I
want to create a new sheet in one of these workbooks where the total in
similar cells in each different workbook can be viewed and manipulated
automatically on that sheet.

As it is now, I have to open each workbook get the total from the
appropriate cell and use a calculator to create a grande total.

Thanks
Tom
 

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

transferring total sheet from one workbook to another 3
move worksheet to end of another workbook 3
Pulling cell information from one workbook to another 3
trouble with closed workbook 2
Using names referencing a cell in another workbook 2
auto copy total from one workbook to another workbook 1
sum across range of sheets for a cost code 1
summary values across worksheets within the same workbook 2

Top