Importing data from other sheets


Posted by Paul on December 14, 2000 5:26 AM

I have a few worksheets that are automatically updated
throughout the day. They have 2 columes each. I want
to combine all them into one workbook having a tab for
each sheet. Cutting and Pasting would work, except I
need the updated material included in the summary
workbook. Any help work be greatly appreciated.

Posted by Loren on December 14, 2000 5:54 AM


R click on a tab; select move; select which file to
move to; select which sheet to locate before/after

Posted by paul on December 14, 2000 6:52 AM

OK, I have done that, but when I make chages, i.e.
append new data to the end, it is not updating
the summary sheets. Now what?



Posted by Loren on December 14, 2000 9:50 AM


I don't understand what your summaries are supposed
to do. Your links are the same as before combining,
I assume.