Search results

@BigD Welcome to Chandoo.org, Glad you are here as per my understanding say your names entered in A1:A100 and you want to find out the how many times a name is entered exp in B2 write the below formula =COUNTIF(A1:A100,"NAME") OR =COUNTIF(A1:A100,C2) C2 is a helper column of the Name...

@Marc as per my understanding say your data in Tab1 Range A1 = 7% in tab2 Range A2 write this ='Tab1'!A1 what ever you enter in Tab1 in the Range A1 it will reflect in the Tab2 Range A1 Hope it clear Thank

@Lohit ya got it it's working nice and cool Thanks bro, thank Q very much

@Kachiba Thanks for your quick response, but the result is not as per my requirement

Hello Good Afternoon how to SaveAs a particular Tab in a new Workbook with fixed formats, xlValues i can manage the code but there is one problem that i have some cells are merged so i can't manage that part here i have a code which is Save As with formulas and fixed formats Sub...

Hi I didn't try the code but i think the error line which he got that is may be myNameF = wk4.Range("Input") i think it is clear for you Ps: this Msg send from mobile that's why i can't check but i guess the error code Thanks

Hi in B2 write the formula =SUBSTITUTE(A2,"Program ","") drag down to ur desire range. say your range is A2:A100 write the formula and drag Now select the range A1:B100 now sort the data with column B hope it solve ur problem other wise please upload a sample file

@Narayan Hello i think the op is try to sort the words using with 9th letter so i think when it is converted in to number format then the result will go fail i think without converting the number format it will possible for sort may be =SUBSTITUTE(A2,"Program ","") and sort, when we sort...

@Sachin it is better to upload a sample file as your desire

@Sachin write the Xiq formula in B2 of FindMacro before you write the code please open both files and write the formula in B2 of FindMacro File =IF(ISERR(MATCH($A2,'[aaa.xlsx]abc Download'!$G:$G,)),"",$A2) for your knowledge i have attached 2 files please download and check, if any...

@Luke yes you are correct

@Abhijeet did you try that code which was given by me

@Abhijeet please try this code in your workbook Module when ever you change in your any worksheet then the workbook will save Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) ActiveWorkbook.Save End Sub Hope it clear your problem other wise please give some...

@SirJB7 Good Day My hearty congrats on your 6k milestone, we are really lucky to get you as a teacher, your solutions, replies, warnings helping nature every thing is good and cool Thanks once again please keep guiding us With Regards

@Luke M my hearty Congrats on your 5k milestone, keep guiding us Cheers :D

@SirJB7 Hello sir, Sorry for my late replay, Thank you very much for your guide lines sir, my system administrator is trying to recover the data and i gave him the details of your also now he trying as per your instruction let see what happen and he told me one part is melted with heat so...

@Luke M Hello Sir, Good Day Sorry for my late replay, sir un fortunately my hard disk is corrupted and i have no data all the backup data also damaged so we are try to recover the data from that hard disk. i tried your latest code in my friend desktop it's working perfect Sir, really...

Hello Sir, Thanks for your New Code I Check with your new Sample Workbook, when i press the PostBooking Button then i got some Msgs they are 1. We are now working with Worksheet:Gate Way 2. inDate has a value of: given date (11/7/2013) 3. outDate has a value of: given Date...

Hello Yes i Double check the code

@LukeM Sorry to give you pain As per you instruction i go through the line by line with pressing the F8 button without any error msg it's pass the line when i reach the line iRow = Range("Dates").Find(inDate, , xlValues, xlWhole).Row when i press the F8 again then i got the error msg for...

Hello Sir again i got the same Object Variable or With block variable not set in the immediate Window i got this Date Range: $A$8:$A$740 indate: outDate: Date Range:$A$8:$A$740 Sir is it possible to chat with you Thanks SP

@LukeM Thanks for your Sample File, sir i have small doubt that is sir i can't understand why the problem is starting from my side when the file is working in your system then why it's not working in mine, off course i am using Windows 8 - Office 2007. is there any option to set in my...

Congrats Sir

@Luke M Sorry for my late replay, as per you new code i change that one but again i get the error code for your reference i attach the file Thanking you With Regards SP

@Luke M Thanks for your code i got one error Msg when i run the code that is Object Variable or With Block Variable not set error line is iRow = Range("Dates").Find(inDate).Row Thanking you With Regards SP