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...