Moving rows based on formatting

**bukimiak** · 02-22-2011, 05:20 AM

Hello!

Today I have something I don't know even how to start.
Therefore, I don't have "starting" code that may be amended.

If it is not too complicated I need a macro, that moves all rows marked with yellow color to the second worksheet.
There is no need to make target rows/columns adjusted.
There may be no empty rows in first worksheet, so after moving a row to second worksheet, the empty one must be removed.

The best solution is to have a macro in separate worksheet, so that it can work on any file opened when file with macro is opened "in the background".
(for example by assigning a keyboard shortcut)

I attach an example files. One with start data and the second one with the desired effect.

PS. IF IT REQUIRES A LOT OF WORK FROM ANY OF YOU, YOU MAY IGNORE THIS THREAD...

**StephenR** · 02-22-2011, 06:53 AM

Do you mean move all the rows which aren't coloured yellow? Are you colouring them manually?

**bukimiak** · 02-22-2011, 07:08 AM

I want to move ONLY yellow-coloured rows.

Some rows are yellow, some are not-coloured.
I want to sort them into separate sheets.
(normal in 1st sheet, yellow in 2nd sheet)

You may see the attachment if it is not 100% clear.

**StephenR** · 02-22-2011, 07:59 AM

Please don't assume that I can't read or am unable to look at attachments.

Your finish file has all the rows which are NOT coloured yellow.

**watersev** · 02-22-2011, 08:05 AM

hi, if I'm not mistaken Excel 2007 has an in-built filter by color ...

**bukimiak** · 02-22-2011, 08:07 AM

I am sorry if you felt offended. I just tried to explain it more.

Please see "finish.xls" file.
1st sheet - only not coloured rows.
2nd sheet - only yellow rows.

That is, all yellow rows from 1st sheet got moved to 2nd sheet.

(maybe I am explaining it wrong way?)

Originally Posted by watersev

hi, if I'm not mistaken Excel 2007 has an in-built filter by color ...

Could you tell me a bit more about it? Sounds promising

**watersev** · 02-22-2011, 08:15 AM

official source of info http://office.microsoft.com/en-us/ex...ont_color,_or_

**StephenR** · 02-22-2011, 08:29 AM

I'm not offended, you seemed to be under the impression I was querying your file without having looked at it. I see now you have split the second file into two sheets. watersev's approach would appear to be the way to go, though you'll need to add a header row.