Copy same rows based on red color cells

**unley** · 03-21-2011, 01:54 AM

I did some search for my request but not to my liking.

I have red interior cells in Column H. I would like to copy same rows from A to H that have red cells in Column H to new sheet

Thanks in advance

Tasks 10_11_dummy.xls

**pike** · 03-21-2011, 03:39 AM

Hi unley
Have you seen this post
http://www.excelforum.com/excel-prog...reen-fill.html

**unley** · 03-21-2011, 06:11 AM

Thank you Pike so I did I miss that one? lol

It was close after I manupilated the codes. This time I tried 2 Sheets without success

Please Login or Register  to view this content.

Tasks 10_11_dummy.xls

**pike** · 03-21-2011, 06:32 AM

Hi unley,

This will copy all the red Interior rows in h column from the to worksheets to overallperformers

Please Login or Register  to view this content.

**unley** · 03-21-2011, 04:06 PM

This is 99% Perfect, the trouble is I can only upload this dummy workbook 'cause the original one is 6mb in size.

This works very well except your code wripe out all my function codes so the "Summary" Sheet show errors

I have CountInteriorColor, GetInteriorColorIndex, SumColor etc functions and after I used your code, I had to reset them all lol

Is there any way of avoiding this issue? Thanks

**pike** · 03-21-2011, 05:15 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**unley** · 03-21-2011, 05:18 PM

Yes I did just that plus added your reputation (good one) until there are major issue with my workbook as you can see my post before you last one. Hope there's around to it

**pike** · 03-21-2011, 05:33 PM

Hi unley
you can zip the workbook. "wipe out all my function codes" what do you mean?
You cant retain a formula in a cell if you copy to it

**unley** · 03-21-2011, 05:45 PM

I have zipped the file for you but I cannot unzip any file from any website at work because of restricted policy with IT.

So if I receive a zip file from you then I can open it when I get home

Tasks 10_11 large dummy.zip

I have no idea why the functions in D2017:O2030 in each yellow tab sheets have to be reset after using your workable codes.

UPDATE: Pike, I've found a solution but putting the copied sheet (overallperformers) to the very last sheet in workbook and have no affect on fomulas so thank you again mate