Excel Help.......

[_poori]

[quote name='badrii' timestamp='1349890777' post='1302605645']
[img]http://www.andhrafriends.com/uploads/gallery/album_20/gallery_24383_20_98587.gif[/img]
[/quote]
[img]https://lh4.googleusercontent.com/-0T8DK0Bahuo/Tc8rrY6f_AI/AAAAAAAACbY/lH3KRvPsrnM/s150/kajal.gif[/img]

[badrii]

[quote name='_poori' timestamp='1349890834' post='1302605653']
[img]https://lh4.googleusercontent.com/-0T8DK0Bahuo/Tc8rrY6f_AI/AAAAAAAACbY/lH3KRvPsrnM/s150/kajal.gif[/img]
[/quote]
[img]http://www.andhrafriends.com/uploads/gallery/album_20/gallery_24383_20_1561642.gif[/img]

[rambabu304]

guys I was in a meeting just came.. I will check for the options that you guys gave me....

thanks in advance........

[rambabu304]

@ POORI & BADRII....

aa LOLLI spamming ni branicha lemu...... megatha vallavii njoy cheyachu... vaadu matram.... vaadu le....booothullu vasthunayi...

coming to the help.........

Sort function aythey every time, when the colors change I have tp do the sort.... I should not change the Row's order.. they should be fixed............

macors use cheyakuda cheyaachaa.... lekapothey have to use macors aa...........

[_poori]

[quote name='rambabu304' timestamp='1349897280' post='1302606224']
@ POORI & BADRII....

aa LOLLI spamming ni branicha lemu...... megatha vallavii njoy cheyachu... vaadu matram.... vaadu le....booothullu vasthunayi...

coming to the help.........

Sort function aythey every time, when the colors change I have tp do the sort.... [color=#ff0000][b]I should not change the Row's order[/b][/color].. they should be fixed............

macors use cheyakuda cheyaachaa.... lekapothey have to use macors aa...........
[/quote]
mostly macros use cheyali emo..if you dont want to change the row's order... macros use cheyali ante developer tab enabled undali... which version of excel are you using?

[150bryant]

to use macro press ALT + F11

[rambabu304]

[quote name='_poori' timestamp='1349897720' post='1302606267']
mostly macros use cheyali emo..if you dont want to change the row's order... macros use cheyali ante developer tab enabled undali... which version of excel are you using?
[/quote]

2010... I am trying to put macros.... never done this but will learn..........

[_poori]

[quote name='rambabu304' timestamp='1349899384' post='1302606467']

2010... I am trying to put macros.... never done this but will learn..........
[/quote]

Step 1: Enable "Developer" tab in Excel as follows:

File -> Options -> Customize Ribbon. On right-side check the box against Developer. Click OK

Step 2: Alt+F11 to open Macros. Then paste the Macros code I sent and save it.

Step 3: Save this as .xslm (Macros-enabled) format.

Step 4: Click on Developer tab on top and click on Macros button. This will show all available macros including this one. Select it and click Run.

PS: The macros code I gave assumes that your data is in column X and there are only three colors (red, green ,yellow).

[rambabu304]

[quote name='_poori' timestamp='1349899923' post='1302606524']


Step 1: Enable "Developer" tab in Excel as follows:

File -> Options -> Customize Ribbon. On right-side check the box against Developer. Click OK

Step 2: Alt+F11 to open Macros. Then paste the Macros code I sent and save it.

Step 3: Save this as .xslm (Macros-enabled) format.

Step 4: Click on Developer tab on top and click on Macros button. This will show all available macros including this one. Select it and click Run.

PS: The macros code I gave assumes that your data is in column X and there are only three colors (red, green ,yellow).
[/quote]

Thanks Poori neenu repu first thing try chestha ..... ee roju vere pani lo busy vundey

Once again thanks