I want to know if it’s possible, and if so how to link “key” fields in MS Excel.
I have user who need to import data from a unix database of store sales. I can convert the data into excel format but based on fluctuations of the stores, that is sometimes a new store opens or one shuts, I cannot import the data direct to a master spreadsheet unless the stores are dynamically linked to each other. Each store has a store code which will be a suitable field for the key.
I want to achieve this link within Excel, database software is not an option.
Thanks
