Search : in
By :

Cut & Paste Coloured Rows to another workshee

Last answer on Jul 4, 2009 11:42:04 am BST scoobii, on Jul 1, 2009 4:21:28 pm BST 
 Report this message to moderators

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

Configuration: Windows XP
Firefox 3.0.11

Best answers for « Cut & Paste Coloured Rows to another workshee » in :
How to cut a mp3 ShowHow to cut a mp3 file ? Need a new ringtone on your mobile ? If you have a mp3 file, but it's too big and your favourite part is at the middle of the file, you can use mp3directcut in order to easily extract any part of a music file. Open...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Copy/Paste problems when using Firefox ShowCopy/Paste problems when using Firefox Pushow Adware Extensions It happens that sometimes, Firefox refuse to copy/paste items. Two assumptions can be made: Pushow Adware You have been infected by an adware, named pushow**.dll...
Download Free Fast MPEG Cut Show
Download Colour Spy Show
Download DzSoft Paste & Save ShowDzSoft Paste & Save are a small handy utility which can save pieces of text on the clipboards for reuse, before overwritten them accidentally. Features: - to sort out the text in three files, - to save all automatically copied texts. DzSoft...
The Colour Table ShowCoding colours In HTML, colours are defined by three hexadecimal numbers, which represent the Red, Green, and Blue tones (using RGB coding) of the chosen colour. This is the syntax for coding a colour in HTML: color="#RRGGBB" RR, GG and BB each...
CSS - Colours ShowColours The CSS standard offers different ways to define colours: by name with hexadecimal notation with decimal notation Applying a colour with its name HTML has names set for a limited number of colours (see HTML colours). The number of...
Computer representation of colour ShowColour representations In order to be able to handle colours correctly and to exchange colorimetric information it is necessary to have the means to categorize them and to choose them. Thus, it is not uncommon to have the choice of the colour of a...
Ask your question Reply

1

Excelguru, on Jul 2, 2009 4:07:54 am BST

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 Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.

   
Reply to Excelguru

2

scoobii, on Jul 2, 2009 8:37:47 am BST

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

   
Reply to scoobii

3

 Excelguru, on Jul 4, 2009 11:42:04 am BST

Hi Scoobii

Get the macro listed here
http://www.ozgrid.com/VBA/ReturnCellColor.htm
and get the cell color in a column and then autofilter or sort to get your data Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

   
Reply to Excelguru
Ask your question Reply
They need your help