Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I've got a workbook with 12 sheets, containing both old an new data. The old data is in red font, the new in blue. A sheet could contain maybe 200 - 300 rows with red font, and 0 - maybe 20 in blue. Is it possible to make a macro, that would copy/collect all the blue rows in all 12 sheets into an emty sheet, leaveing the copied rows red, in the original sheets? Best regards Henrik Bonde Btw. Don't hit the emailreplybutton. My header replyaddress don't work Reply to group :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA sort range with certain fontcolor | Excel Discussion (Misc queries) | |||
keyboard shortcut for fontcolor change in excel2002 version? | Excel Discussion (Misc queries) | |||
Sum the values of cells based on fontcolor | Excel Worksheet Functions | |||
bookmark or hyperlink? | Excel Discussion (Misc queries) | |||
Hyperlink to a bookmark | Links and Linking in Excel |