Search results

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

@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...