Good morning all
I would like to create a replace all command where it replaces the first section of the formula which is quoted
with whatever is in Cell G1
so for example if the formula is
=VLOOKUP("CP6 Opportunities & CP7 Development",'Head Count - Out Turn'!$E$7:$K$1710,2,0)
and i then select "Remitted Schemes" in the drop down in cell G1 it then changes the formula to
=VLOOKUP("Remitted Schemes",'Head Count - Out Turn'!$E$7:$K$1710,2,0)
Thanks in advance
I would like to create a replace all command where it replaces the first section of the formula which is quoted
with whatever is in Cell G1
so for example if the formula is
=VLOOKUP("CP6 Opportunities & CP7 Development",'Head Count - Out Turn'!$E$7:$K$1710,2,0)
and i then select "Remitted Schemes" in the drop down in cell G1 it then changes the formula to
=VLOOKUP("Remitted Schemes",'Head Count - Out Turn'!$E$7:$K$1710,2,0)
Thanks in advance