Recent content by santoshsapre

Faseeh, great!! its work. Thanks a lot.

Hi, I have 12 digit ID number in column A in which 7th digit of no. is scheme code for number start from other than 9 and 5th digit is scheme code in number start from 9. Pls note that ID number is in the txt format as it's downloading from other system.i have tried to convert in to number...

Thanks u sir, i agree with u, as am very much new to vb coding, i am trying to learn something new from excel guru like you all. Thanks once again..will trouble you again for help.

Sir have tried to record macro as below.but not clear on the "Programmer tab, Code (first) group, Record Macro button. Or just press the dot at the left bottom corner of your screen." can u pls help. Sub Macro3() ' ' Macro3 Macro ' ' Range("A6").Select Selection.Copy...

Hi, i have workbook having around 25 sheets , i want to change all sheet name as per value in cell A6. Required macro for the same.

Dear Narayan, not hear from u..

Hi, I have around 25 sheets in the workbook. inpute data start in every sheet from A7 but there is some sheet wherein no data. i want to print all sheet only if there is data in A7 currently i am clg+select sheet with data available and then print. is there any solution thru macro which by...

Dear Narayan, the reason for the macro is that the validation checking is done by my junior and i don't want to show them formula to avoid any wrong result by changing modification ("UNGLY")in the formula by them which may trouble for me. if possible pls try to provide macro. Thanks!

Hi, I want to make Date entry form in excel to inpute data in two field. ( chq no ) and ( amt. ) after entering the number in chq no filds and enter cursor shuold go to amt field and again after enter cursor shuold be on chq no field. without using any tab or arrow key. date should save in...

Hi, I have workbook having around 25 sheets with various no of data, i just want macro to merge all sheet in last sheet one after one and so on....

Dear OC, have tried your formula and getting correct result as required...many thanks!! Dear Narayan, now your revised formula working correct as required. Thanks once again!! one more help required. how to add this formula in macro??

Dear Narayan have tried on my main data and observed that below two names are differ only one common name is Bajpai but still result showing as TRUE its should be false. columen A column B Result MANJRI LADA BAJPAI R N BAJPAI TRUE pls advise

Dear all, Hats off to you all!!! Thanks for your all efforts. Dear NARAYANK991, its works!! can we add this in to macro. Thanks once again.

Thanks for the solution, but can u pls try to compact formula as i have to check almost more than 9,000 names on a daily basis and as per above formula will have to split both the column and then apply formula in 3 diff column to get the result. i think this will very time consume process. Pls...

Thanks for your promt reply ... not clear above formula, could u pls add in my xls attached and send to me. there will be 2 or 3 names in one cell . Cell A3 should check any 2 name with B3 and if match any 2 name then result should be as TRUE requied in c3. Pls help