Hi
I have a spreadsheet where the data in columns A & B (STOCK_CODE & DESCRIPTION) are imported from our accounting programme using GET EXTERNAL DATA. In cell C7 I enter a price for the the stock code shown in cell A7. If someone enters a new STOCK_CODE & DESCRIPTION in the accounts programme and refeshes the spreadsheet then the price entered in C7 is no lnger aligned with cell A7. How can I keep the price in sync with the STOCK_CODE & DESCRIPTION.