Search results

Luke M sir it is good to see someone ask question & it responded quickly & ending with tag Now what? eagerly asked.....

@Luke M Thank you sir for your kindly support. You solved my another problem which became headache to me.

@NARAYANK991, Hello sir I am waiting for your response sir.

Hello sir, please help me to find out problem in my code.

@Luke M Hello sir, old Problem became headache. Could you sort this out.

I think sir problem is between these code & need some modification. If WorksheetFunction.CountIf(Union(BRange, CRange), "YES") = 0 Then 'Do nothing Exit Sub ElseIf WorksheetFunction.CountIf(BRange, "YES") = 1 Then 'only 1 YES found Set CutRow = BRange.Find("YES").EntireRow ElseIf...

sir only that cell will move up the order, if we descendent the cells then it will replace the originality. in my workbook A11 row has both YES in col D & E so it move up the order to below the cell A5 row then i have to mark it X so that next cell with condition fulfill will move up the order.

thank you sir for your response. i will elaborate it. sir can you check it through team viewer. sir in code there is a timestamp which store I value of selected row. range is those rows whose timestamp value of col G. If i select any cell of A11 row then range will be those G cells whose...

sir, when color cells move up the order then they do not push down the cells below. As in above when color cell 4 & 6 move up the order below 2 then cell 3 go to position 6. i want when cells move up then the cells below them just push down. No 3 cell just push down two cells below as 4 &...

@NARAYANK991, hello sir, did you sir out solution to this.

@SirJB7, Hello sir, I briefly describe it, my problem is the code only find out first YES in col D & move it up,it does go further as written in code,So sir could you find out where is bug there.

hello sir, Thank you for response. I briefly describe what is need. In my uploaded worksheet, I want to move the cell up to order basis on some condition, in D col if one YES is found & then it move up order.If there is multiple YES found then which correspondent E col is YES will move up...

hello, Can someone told me why above code do not find out next YES in col D.

hello SirJB7, my problem is code below does not work. ElseIf WorksheetFunction.CountIf(BRange, "YES") > 1 Then 'multiple YES found in col B With BRange Set c = .Find("YES") firstAddress = c.Address 'Check for corresponding C value If c.Offset(0, 1) <> "YES" Then Do Set c...

@SirJB7 hello sir, could you find out the problem in my uploaded file. I think this section does not work ElseIf WorksheetFunction.CountIf(BRange, "YES") > 1 Then 'multiple YES found in col B With BRange Set c = .Find("YES") firstAddress = c.Address 'Check for corresponding...

@Luke M, Hello sir, i have a problem, when i run macro it is not working. http://www.2shared.com/file/2X6TsOBe/as2.html

http://www.2shared.com/file/ReYHgRyX/color.html correct format will be as in sheet2

@NARAYANK991, hello sir, i have some problem when i used this macro in following sheet. http://www.2shared.com/file/Cd9w25vD/color.html color cells move up but it does not push down the cells. As here when i select col B6 & run macro color cells move to below B6 but the cell B7 does not...

@SirJB7, hello sir how are you. @Luke M. welcome to forum after a break.

welcome back sir Hui. And About SirJB7, he is a rescuer.

@SirJB7, Thank you sir for time give to me.

Just sent. Edited because privacy concerns.

thank you bobhc for your kindly support.

@SirJB7, Thak you sir co-operation. sir my workbook ends with .xlsx. Is there any problem in that. Yes i use TeamViewer software.

hi, i used 2007 version. Can someone post a work book with same thing.