macro vlookup if replace

  1. G

    Macro to perform vlookup and run 'if then replace with' on neighbouring cell

    hi i have 300 excel files to edit. i've simplified my problem to see if you can help me. i need a macro that will: find 20 in column A (vlookup? - it could be on any row) if the cell next to it (column B) contains 0 then do nothing if the cell next to it (column B) contains 60 then change...

Some videos you may like

This Week's Hot Topics

Top