Search results

@SirJB7 your wording is true, also fan of games but now few months away from game due to eye prob Love to play in any platform from old console to android, give me one the party is on.

Luke, Definitely he is one. @bobhc I have no idea that here also i can find game follower.

@montrey sorry i can't get you. About who you talking about.

@Luke, that work fine by inter changing rows condition B & C. sir, one thing i must say, Excel Ninja Tag does not come with an ease. you truly deserve that.I wonder how ease you do that which takes all my efforts, thanks for your help & appreciate your work. if need any further help...

hi, Luke here is my example before & after look. EX-1 ------ A B C D 1 NO NO 2 NO YES 3 NO YES 4 NO NO AFTER ------ A B C D 2 NO YES 1 NO NO 3...

Hi, A B C D 1 2 3 4 5 6 Column A is simple serial nos. I am wondering there is any way that if i randomly select any no of cells ( i.e. 1-4 or 1-6 or 1-3 ) & then run a macro then a single cell move upwards with minimum row value of column A ( i.e if i select row...

SirJB7, it works fine but has one problem. ActiveWorkbook.Worksheets("Sheet1").SORT.SortFields.Add Key:=Range("E5:E8"), _ SortOn:=xlSortOnValues, Order:=xlAscending, CustomOrder:="TSL", _ DataOption:=xlSortNormal when it sort using 2nd condition, it sort first TSL then alphabetical order...

Thanks Luke M & SirJB7 for your help. SirJB7, i will definitely keep those in mind. thanks again, if need any help ask you again.

help me for sorting as i can't find any solution.

hi, SirJB7 please select D5 cell and go to custom sort, what is there i want to do with macro when select some rows i.e. every time i select rows & run macro it will produce result what is produced by custom sort.

here below is macro code. Sub SORT() ' ' SORT Macro ' ' ActiveWorkbook.Worksheets("Sheet1").SORT.SortFields.Clear ActiveWorkbook.Worksheets("Sheet1").SORT.SortFields.Add(Range("F5:F8"), _ xlSortOnCellColor, xlAscending, , xlSortNormal).SortOnValue.Color...

http://www.2shared.com/file/F1kd1Ccn/New_Microsoft_Office_Excel_Wor.html here is my work book. please go to custom sort to see what i want.

i record macro but it sort only those cells which selected during record macro what to do now

second row ETB is calculate as " =IF(D2<(F1+(2/24)),F1+(2/24),D2) " ETC is calculated as ETB+4

Hi, all I want to record a macro with custom sort with different level.When i select some rows then it sort according to custom sort which is store in macro. please help me. Thanks in advance.

i want to sort the order means move the row up to order on priority basis when it go through the condition as i mention earlier.

yes. will you please tell me how to move up to order the row which get 1st priority after going through the condition mention above.

1st row is given. with respect to it i take rows 2 through 5 because these rows are available to me at the time of calculating.Similarly after calculating it rows 6,7,8 are available to me. Let me know which part is confusing so that i can explain it more.

it is quick response from members thanks for that. Sorry for information i provide you, I can't express what i want.So, please go through it again. SN CUST CAP ETA ETB ETC 1 BEL YES 15-May-12 02:00 24-May-12...

Hi, Can anybody help me, my scenario is as below I have 5 column named as SN, CUST, CAP, ETA, ETB. i want to calculate & sort ETB column depending on CUST, CAP & ETA column. SN CUST CAP ETA ETB 1 BEL YES...