Keep reference to a cell when column is deleted

Hi

You can do it on the basis below but you will need to adjust the ROW statement if the information in the two sheets is not in the same row e.g. ROW()+5

=INDIRECT("your_sheet!Your-column"&ROW())

Ed