Search results

@Hui Sir after long time i got replay from you, Thanks a lot for your replay as per your instruction i check for addin 1. Click the Excel Option 2. Add in 3. Manage (Excel Add-ins) 4. Go now it's display the Add-ins box without Right Click 1. Analysis Tool Pack 2...

@Narayan Sir, Thanks for your quick reply no i open only my excel workbook only with Tally package and Mozila Firefox that's all

@Shrivallabha Thanks for your quick response and your valuable Msg, you are correct with given link no body will sure that is works perfect @Narayan Sir Thanks for your replay, as per your points 2. The File Crashes while on using after some time when it's going to Calculate and Save...

Hello Friends I have small request why our some excel files are crashed after some times, how can we identify the problem, is there any way to trash out why the file is crashed. When i Google search then i got this http://www.appspro.com/Utilities/CodeCleaner.htm but i didn't check this...

@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