I need help on a macro that will scan all the worksheets in a file and find red cells. The macro should copy the entire row of the red cell and paste it to new sheet. It should find red cells from the entire worksheet
I need help on a macro that will scan all the worksheets in a file and find red cells. The macro should copy the entire row of the red cell and paste it to new sheet. It should find red cells from the entire worksheet
Maybe something like this:
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Can you post a sample workbook with examples of the data layout?
Will the red cells always be in ONE column or throughout many? I ask because looping through ALL cells is not very efficient, but looping through a column might be faster or applying a filter to the entire sheet might be the fastest.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks