Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data import from different excel files & automatic refresh
From 10 excel files (different countries) with 12 tabs (different information
about the countries), I need to create a new excel file that will contain 10 tabs (the countries) with selected data from one of the 12 tabs. This data must be stored in different sheets and then it is going to be consolidated (so I must have one tab for each country). It is very crucial that this data is refreshed automatically, since there are going to be several changes by the countries and we want to avoid any errors. Is there any way to do this? I know about links, but we dont trust them. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error on Refresh Data Import from Access | Excel Discussion (Misc queries) | |||
automatic formatting on import of .DIF files | Excel Discussion (Misc queries) | |||
Automatic refresh of external data | Excel Discussion (Misc queries) | |||
How do i refresh external data import in excel in seconds | New Users to Excel | |||
Automatic refresh of external data | Links and Linking in Excel |