New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Red font Color Copy and Paste to a new Sheet

Macros, VBA, Excel Automation, etc.

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 31 guests