Hey

I have a workbook where I in one sheet referes to a value from a cell in another sheet.

I have many of those I have to change every week.
Is there a way to do it without manully changing the value of the cell.

To explain better take a look at the attached file.

Where I in sheet2 refers to the cell in sheet1.
In sheet2 I want to change column A so it doesn't refer to column A in sheet1 but to column B in sheet1.
But i don't want to write it in the cell.

I thought there might be a formula which did this?

Kind regards
HessingExcelForum1.xlsx