Sorting Excel sheet by cell colours
Thread poster: Csaba Ban

Csaba Ban  Identity Verified
Hungary
Local time: 02:45
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.


 

Csaba Ban  Identity Verified
Hungary
Local time: 02:45
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 thoughicon_smile.gif


 

Robert Zawadzki  Identity Verified
Local time: 02:45
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 thoughicon_smile.gif


 

Robert Zawadzki  Identity Verified
Local time: 02:45
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 thoughicon_smile.gif


 


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






SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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