G
Guest
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
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