Amalgamate Several Worksheets into one file thru Data import
 

I am having 12 files in different network locations. Each having one
worksheet inside. I just want to know whether I can create one file in my
hard drive and create 12 worksheets and Import External Data to each
worksheet from the different files so that I can see all of those worksheets
in indifferent network locations into one file. I tried the External Data
Import & Refresh but the command refreshes only the cells that contained data
at the time of setting up. New cells edited doesn't appear in my amalgamated
worskbook (also cells that contain formulas in the source files, when
imported are reflected as blank cells)
Anybody can help me on this? I just want to create a copy of all those
worsheets in my combined file when i open the combined workbook...
--
M Imran Buhary

Amalgamate Several Worksheets into one file thru Data import
 

The simplest approach might be to use a macro to open each of the
source workbooks in turn and copy the worksheet into your master book.

You could do most of it by using the macro recorder.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup