Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!
View Course

Red font Color Copy and Paste to a new Sheet

Macros, VBA, Excel Automation, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

Red font Color Copy and Paste to a new Sheet

Postby laurensims41 » Thu Oct 27, 2016 7:25 pm

I have a rather lengthy tracker that I would like to condense based on certain cell's font color.

I need to loop through the whole tracker and find the red colored font cells and move them to another sheet with keeping its column in tact.

I have attached the spreadsheet and an example of what I am looking of on Sheet 2 labeled PO's Not Received. I don't need to keep that exact format on Sheet 2, but I would like the columns to move over with the red text from the first sheet along with site names.
  • 0

You do not have the required permissions to view the files attached to this post.
laurensims41
Rookie
 
Posts: 15
Joined: Feb 3, 2016
Reputation: 0
Excel Version: Office Professional Plust 2010

Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 4 guests

cron