Technical forums » General technical issues »
Sorting Excel sheet by cell colours
Thread poster: Csaba Ban
Csaba Ban
Csaba Ban  Identity Verified
Hungary
Local time: 00:12
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?
... See more
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. ▲ Collapse
 
Csaba Ban
Csaba Ban  Identity Verified
Hungary
Local time: 00:12
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
 
Robert Zawadzki (X)
Robert Zawadzki (X)  Identity Verified
Local time: 00:12
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
 
Robert Zawadzki (X)
Robert Zawadzki (X)  Identity Verified
Local time: 00:12
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
 


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

Moderator(s) of this forum
Laureana Pavon[Call to this topic]

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

Sorting Excel sheet by cell colours






Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »
Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »