Cut & Paste Coloured Rows to another worksheeClosed

Question

Hello,

I have a spreadsheet with just over 5000 rows with each row being 1 of 5 colours. I need to cut and paste all rows of  a specific colour (colour 16 I believe) to another worksheet. There are no empty spaces in any fields and the row starts at column A and ends at column J.

If possible, do you know how to use a macro to delete all the empty rows afterwards?

My VBA knowledge is at a real beginner level and Ive tried amending various results I've googled to no avail. Any help you can give will much appreciated.

Regards,

scoobii

Excelguru · Answer

HI scoobii

If you are using Excel 2007 you can use autofilter Then you are able to display cells using specific colours
The press CTRL + G  >> Special>> Visible Cells only
Then copy and paste to other sheets

I dont know whether this feature is available in Excel 2003
Just check

scoobii · Answer

Hi,
Thanks for your response. I'm working on Excel 2003 unfortunately and I'm trying to actually filter out the coloured rows, not keep them. As the data in the same coloured rows are different, its difficult to apply a data filter to them hence why I'm trying to filter by colour. I'm working on it today but any help you could give will be very appreciated!

Regards,

scoobii

Excelguru · Answer

Hi Scoobii

Get the macro listed here
https://www.ozgrid.com/VBA/ReturnCellColor.htm
and get the cell  color in a column and then autofilter or sort to get your data

Cut & Paste Coloured Rows to another workshee

3 responses

Similar discussions

Subscribe To Our Newsletter!