D
Darren
=CONCATENATE("='Products'!",C30) is what is in Cell H23
and it produces output of ='Products'!F2
The problem is, I don't want it to display ='Products'!F2
I want to display the value of F2 on worksheet Products
I use a combobox and the value goes into C30, so this is
dynamically driven. Is there a better way of going about
this other than using concatenate? Thanks in advance.
and it produces output of ='Products'!F2
The problem is, I don't want it to display ='Products'!F2
I want to display the value of F2 on worksheet Products
I use a combobox and the value goes into C30, so this is
dynamically driven. Is there a better way of going about
this other than using concatenate? Thanks in advance.