Select Rows Based On Row Color

**nrichardson** · 06-25-2012, 09:18 AM

Hello,
I have a very large excel spreadsheet that we use to store information of clients. I have found a script so that I can click on column A and it will highlight that row in a certain color ( color id is 35 ). What I need to be able to do is, once I am done selecting a number of clients, I can use a macro to copy just those rows into another sheet! I have found some scripts but they don't seem to work because my spreadsheet is around 9,000 lines long. Also, its columns A-L that I need copied into a new sheet! (It would be nice if once that macro ran, it would also switch to the new spreadsheet!)

Thanks!

**K m** · 06-25-2012, 10:22 AM

Post an example file

**nrichardson** · 06-25-2012, 10:53 AM

I have posted an example. You may need to enable the macros because I need the new macro to work with the old one. If you click in column A, it will highlight the whole row and the highlighted rows are the ones I need copied into a new sheet! Thanks again!

**nrichardson** · 06-25-2012, 11:42 AM

I have found this code that's "supposed" to work but can't figure out how to select all rows with the color index of 35?

Please Login or Register  to view this content.

**nrichardson** · 06-25-2012, 11:54 AM

Well, looks like after almost a week of looking, I have finally found the answer!

Please Login or Register  to view this content.

Select Rows Based On Row Color

LinkBack

Thread Tools

Rate This Thread

Display

Select Rows Based On Row Color

Re: Select Columns

Re: Select Columns based on row color

Re: Select Rows Based On Row Color

Re: Select Rows Based On Row Color

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions