Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Amalgamate Several Worksheets into one file thru Data import
I am having 12 files in different network locations. Each havinf 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 |
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) |