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
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