| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Rows that have a Green font color to another worksheet
Hi I really need some help. I have a worksheet with columns A-P Rows 5 - 350 Some rows I have green font color the rest are black font color I have the letter "G" for green in the column P for the rows that are green. I need to code a command button that will look for the letter "G" and get these green rows and copy them to another worksheet titlled "Rolls to be Pulled" in the same workbook. I have tried everything I can think of Please help. Thanks Charles Alexander -- mrdata ------------------------------------------------------------------------ mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899 View this thread: http://www.excelforum.com/showthread...hreadid=511536 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell and the font color | Excel Discussion (Misc queries) | |||
| Retain font/cell color on lookup/copy | Excel Worksheet Functions | |||
| Change font color in protected worksheet | Excel Worksheet Functions | |||
| How to enable font color on protected worksheet? | Excel Discussion (Misc queries) | |||
| How copy format, font, color and border without copy/paste? | Excel Programming | |||
Threaded Mode
