Macro To Update Cells In Work Sheet

Hello,

Thank you. Sorry, I am new to Excel language. I do not understand how the code =VLOOKUP(A1,Master Sheet!A:C,2,False) knows how to replace pricing in current sheet? I just see Master Sheet in code?? Sorry.. I also tried to paste it in the A1 cell of current sheet, and it just brings up a window.

Thanks JR

Originally Posted by gaspower

Hello,

Thank you. Sorry, I am new to Excel language. I do not understand how the code =VLOOKUP(A1,Master Sheet!A:C,2,False) knows how to replace pricing in current sheet? I just see Master Sheet in code?? Sorry.. I also tried to paste it in the A1 cell of current sheet, and it just brings up a window.

Thanks JR

Hi,

I'm attaching an example workbook showing the VLOOKUP() formula in column F of the Current Sheet.

Regards