I need urgent assistance for the following.
I want to delete entire rows from a spreadsheet when cells Gx = Fx
e.g. when the value G6 = 20 matches value in F6 = 20 than the entire row needs to be deleted
I am aware this is easily to be done manually but it is a huge data dump which is run multiple times a day my clients prefers automating this by creating a macro.
Hope this is clear enough.
thanks in advance for your help!