I'm trying to figure out a way to search Column Q for a red Cell. If it is Red then it will copy the entire row and paste it into the First available row in Sheet 2. It will then go back to Sheet 1 and delete that row that was just copied. Can anybody help me with this. Any help is appreciated.
I am assuming you are using conditional formatting to make the cells red? It would be easier to use VBA to check for the same thing as conditional formatting. What makes the cell red?
Maybe something like:
Please Login or Register to view this content.
I have another macro that makes it red. I don't use conditional formatting.
another method
this is currently set for yellow
Please Login or Register to view this content.
Last edited by Sean Thomas; 07-25-2013 at 09:48 AM. Reason: typo error
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Thank You it works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks