Mobile menu

Sorting Excel sheet by cell colours
Thread poster: Csaba Ban

Csaba Ban  Identity Verified
Hungary
Local time: 01:59
Member (2002)
English to Hungarian
+ ...
Jul 9, 2003

I have a sizeable Excel sheet (around 3000 rows), where each row is either painted yellow, green or pink. The yellow and green rows contain strings already translated (thus good raw material for building a terminology / translation database), whereas the pink rows are translatable (only source segment available).

Is there any easy (or not-so-easy but still feasible) of sorting the rows in this sheet according to cell colour and in the end reinstaling the original row sequence?

I can manage with macros, but I am afraid I would need Visual Basic here, which is beyond my competence.

Any useful ideas will be appreciated.


Direct link Reply with quote
 

Csaba Ban  Identity Verified
Hungary
Local time: 01:59
Member (2002)
English to Hungarian
+ ...
TOPIC STARTER
Got the answer Jul 9, 2003

For future reference, for anyone who might need to do the same thing:
http://www.cpearson.com/excel/SortByColor.htm

I still have to understand it though


Direct link Reply with quote
 
Robert Zawadzki  Identity Verified
Local time: 01:59
English to Polish
+ ...
My solution is the same, but I hope a bit easier to understand Jul 9, 2003

And without writing any code.
But one thing: I have Excel 2002. I do not remember how it works in earlier versions.

Csaba Ban wrote:

For future reference, for anyone who might need to do the same thing:
http://www.cpearson.com/excel/SortByColor.htm

I still have to understand it though


Direct link Reply with quote
 
Robert Zawadzki  Identity Verified
Local time: 01:59
English to Polish
+ ...
My first answer did not make to the forum, somehow. Jul 9, 2003

If you are still interested in a solution without programming, let me know.

rzawadzk wrote:

And without writing any code.
But one thing: I have Excel 2002. I do not remember how it works in earlier versions.

Csaba Ban wrote:

For future reference, for anyone who might need to do the same thing:
http://www.cpearson.com/excel/SortByColor.htm

I still have to understand it though


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Sorting Excel sheet by cell colours

Advanced search






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs