Hello, Hoping someone can help me. I'm trying to create a macro that will locate a red cells in Column A then copy that row into sheet 2. It will then go back to sheet 1 and continue down column A and do the same process if it comes across another red Cell. I created a macro to find duplicates so the cells are not being changed by conditional formatting and this macro being created would be the next process. I know I can probably do this with conditional formatting or another manual way but I will have this program running in the background while I am working and do not need to be clicking a button for each step. I will have roughly 65k files in column A so I know this will take some time to go through and that is another reason why I would like to not have to do it manually. Any help is appreciated I've tried several options but none of them are what I'm looking for. Any information is greatly appreciated.
Bookmarks