joeltider
03-10-2016, 10:35 AM
Good Morning here is my current setup...
In a sheet named "Copy" Cell O1 contains a number which will change each time.
In a sheet named "Paste" there are rows sorted based on another macro.
My question, how do I write a macro to highlight rows in "Paste" based on the number showing in sheet "Copy" Cell O1? When highlighted I want to delete the information. I have done this before and now im stuck for some reason.
Thanks!
In a sheet named "Copy" Cell O1 contains a number which will change each time.
In a sheet named "Paste" there are rows sorted based on another macro.
My question, how do I write a macro to highlight rows in "Paste" based on the number showing in sheet "Copy" Cell O1? When highlighted I want to delete the information. I have done this before and now im stuck for some reason.
Thanks!