Hi all,
I have a VBA when it will execute after a hotkey is pressed. Basically to vlookup the value present on cell B onto C, D, E, etc.
If I want to modify it such that it will detect that there is value in cell B2, and automatically execute the vlookup in C2, D2, E2, etc.
Right now, if any of the cell in B is changed, will need to press the hotkey for them to re-calculate.
Attached is the excel screenshot.
Any help will be appreciated, thanks a lot.
2013-03-03 23_43_01-Microsoft Excel - Label Issue - RTS List - Supplier Info.png
Please Login or Register to view this content.
Bookmarks