Dynamic cell references

[glynn1969]

Hello I am looking for some vba please. I am looking for some vba please.

In my workbook I have 2 tabs CUURENT and REFRESHED, I am liking some vba that will recognise what cell I am active in on the CURRENT sheet eg CURRENT cell B7 and the insert a reference in this cell to refer to the same cell of my REFRESHED tab.

So in CURRENT cell B7 I would get =REFRESHED!B7.



Extra cheeky question....bonus point

If possible could the vba look down column C of CURRENT sheet and where it finds a cell value of 1, it would insert the dynamic formula in B.

So if CURRENT C7 had a value of 1 then in CURRENT B7 the formula =REFRESHED!B7 would be entered..

Any help much appreciated

 

[Micron]

I'll try the first question for now, but you might need to specify what event will make this happen if you can't take it from here. Could be just selecting a cell, could be a cell double or right click, could be a command button...

If Sheets("CURRENT").Range("C7") = "1" Then Sheets("CURRENT").Range("B7").Formula = "=REFRESHED!B7"