Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
import data from a text file | Excel Discussion (Misc queries) | |||
Search/Extract Data w/in Text File | Excel Discussion (Misc queries) | |||
Import data file but exlude information I already have in sheet? | Excel Discussion (Misc queries) |