Search results

@Vds did you try as per deb solution =SpellNumber(Round(A1,0)) off course i don't have the Excel 2003 but i save a sample file in the format of 97-2003 and i run the code it's working =SpellNumber(ROUND(A1,0)) if any problem please let us with your sample file Thanks

@Samantha Glad your problem solve, welcome back if any problem Thanks

@Praneeth may be this will help, please try the below code in Tab birth-day reminder range("E9") =IF(C9=TODAY(),HYPERLINK("mailto:"&D9&","&G9&"?subject="&C$4&"&body="&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($C$5,"$",B9),"@",$C$6),CHAR(10),"%0a"),"send e-mail"),"") say you have another email id...

Samantha Try This Code, which is the Luke Sub FilterData() Sheets("Ending point - expected result").Select Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select 'Selectnion.Clear Selection.Clear...

@Samantha can you give me some idea, actually what do you want to do and which column base the data will transfer to next tab. I am little bit confuse on that, as per my understand in your first tab (Starting point - ALL Notes (SS) of the Column C has some note_text as cancel and comp these...

@Samantha Welcome to chandoo.org, it is better to upload a sample file with your desire result Thanks

my hearty Congrats Bobhc for your 2k milestone keep guiding us and be fast With Regards

Hi Thank You,

and also check this link too http://chandoo.org/forum/threads/data-transfer.11837/#post-69406

@krispar Please Check This link may be it will give some idea to you http://office.microsoft.com/en-in/word-help/link-or-embed-an-excel-worksheet-HA010120810.aspx Thanks

@BigD Thanks for your kind words, glad your problem solve Thanks

@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