Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using external data with differing formats in a spreadsheet
I am using external data to populate one spreadsheet, and then I link to this
data in several other spreadsheets. The only problem, is that on occasion, the format of the external data changes (eg. 1 less column of data), and this in turn upsets my other spreadsheets as they are linked to the spreadsheet which is populated with the external data. I have tried to play around with some lookups, but as I will have to lookup the month (the row heading) and the column heading, I cannot seem to create anything that is meaningful. Hoping someone can help Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Import External Data | Excel Worksheet Functions | |||
inserting rows through external data source | Excel Discussion (Misc queries) | |||
refresh external data on a protected sheet | Excel Discussion (Misc queries) | |||
Excel 97/2000 - Help with looking up external data. | Excel Worksheet Functions |