Macro for formula need to change based on cell value

[maheshrk81]

Hi All,

I need a macro where the formula should get updated based on cell value.
I have a refresh button, when i select the refresh button, my Cell T1, U1, V1 and W1 should get updated as below.

If my Cell "A1" is "All" then Cell T1 "All" else "Vlookup(formula)".
If my Cell "B1" is "All" then Cell U1 "All" else "Vlookup(formula)".
If my Cell "C1" is "All" then Cell V1 "All" else "Vlookup(formula)".
If my Cell "D1" is "All" then Cell W1 "All" else "Vlookup(formula)".

Thanks in Advance.
Maheshrk

 

[wideboydixon]

Oops. Lazy cut and paste with no testing. *Blush*. Thanks Peter.