HI, im looking for a VBA code that will help me with an issue. i have data in column N but if in column O the cell is blank i need it to move the value below up so the cell in column O is no longer blank.
essentially this if IF column N has a value and column O is blank copy the value below up from column O.
can someone help, been searching online and cant find much. i can get it working for a formula but i need to to run via a button and i needs to run on 10000 cells.
thanks!
essentially this if IF column N has a value and column O is blank copy the value below up from column O.
can someone help, been searching online and cant find much. i can get it working for a formula but i need to to run via a button and i needs to run on 10000 cells.
thanks!