Specific cell locking question

Kenn!

New member
Joined
Mar 18, 2014
Messages
2
Reaction score
0
Points
0
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?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
You could use

=INDIRECT("B4")
 

Kenn!

New member
Joined
Mar 18, 2014
Messages
2
Reaction score
0
Points
0
Thx for the advice @Bob :) However INDIRECT gives reference error when referring to another worksheet
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Does it? I thought it referred to another sheet just as easily

=INDIRECT("Sheet2!B4")
 
Top