Sorting Excel sheet by cell colours
Thread poster: Csaba Ban

Csaba Ban  Identity Verified
Hungary
Local time: 01:36
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: 01:36
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 (X)  Identity Verified
Local time: 01:36
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 (X)  Identity Verified
Local time: 01:36
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






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »



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