Hi Guys
I have a very specific question for all of you.
I'm an economy student and are currently working with daily currency convertion rates.
In my worksheet i reference to the worksheet, in which my daily rates, so that shows the overview of present financial activs are in current day curreny.
Here is my question:
How do I lock a specific cell(in this case B4), in reference worksheet, despite adding new rows?
Any helps?
I have a very specific question for all of you.
I'm an economy student and are currently working with daily currency convertion rates.
In my worksheet i reference to the worksheet, in which my daily rates, so that shows the overview of present financial activs are in current day curreny.
Here is my question:
How do I lock a specific cell(in this case B4), in reference worksheet, despite adding new rows?
Any helps?
However INDIRECT gives reference error when referring to another worksheet