View Single Post
  #1   Report Post  
ac512
 
Posts: n/a
Default 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