Re: $$Excel-Macros$$ Remove Duplicates

Its working, Thank you Ashish for your help :) Thanks, Waheed On Fri, Jul 11, 2014 at 9:51 PM, Ashish Kumar wrote: > Hi Waheed, > > PFA sheet and its code is working on Column D only. > > > Regards > Ashish > > On 11 July 2014 20:58, Shaik Waheed wrote: > >> Yes Ashish, >> >> I only need one

Re: $$Excel-Macros$$ Add Control On button click on Page

Hello Expert, Please help On Sun, Jul 13, 2014 at 3:44 PM, Rupesh Patil wrote: > Any suggestions > Experts > On 12-Jul-2014 11:33 AM, "Rupesh Patil" > wrote: > >> >> ​Hello Expert, >> >> I need a help from you. I want ​to add textbox on page when each time >> button click and add rows in exce

Re: $$Excel-Macros$$ Filter but exlude bad results script help!

Here you go.. On Fri, Jul 11, 2014 at 10:04 PM, Matt Painter wrote: > I pull data from a site called NDRIN.com its nd's land data base that i > work off. Now i have a script that filters the results when i > searchwhich is great.. but these admins dont enter the stuff right.. > alot.. > > S

Re: $$Excel-Macros$$ Remove Duplicates

Hi Waheed, Welocme. Regards Ashish On 14 July 2014 14:08, Shaik Waheed wrote: > Its working, Thank you Ashish for your help :) > > Thanks, > Waheed > > On Fri, Jul 11, 2014 at 9:51 PM, Ashish Kumar > wrote: > >> Hi Waheed, >> >> PFA sheet and its code is working on Column D only. >> >> >>

$$Excel-Macros$$ Re: Multiple Web Page Extraction

A great first effort Pramod. I called it up a few times. I always get the same 3 first lines returned - then I get the following error from your code and it stops: wk.Cells(i, x).Value = TDelement.innertext Perhaps it has something to do with the amount of time that the site needs to load. I

Re: $$Excel-Macros$$ Add Control On button click on Page

I'm sorry, there just doesn't seem to be enough information to figure out what it is you want to do!   Are you saying you wish to add information to the worksheet when you hit the button? or are you wanting to create another set of text boxes on the userform?   If you're wanting to create new tex

$$Excel-Macros$$ How to direct multiple hyperlink ?

Dear Aii experts, Please help in my query!! Please find the attachment explained clearly. How to direct multiple hyperlink ? There are web hyperlink in left side: All the link contain table in website The table from website should pull down and copy and paste in "MainCollectionSheet" as shown ex

Re: $$Excel-Macros$$ How to direct multiple hyperlink ?

Hi Nitya, I have added a FOR-LOOP and tweaked the macro a little which allows you loop through all the table-hyperlinks in your link sheet and then performs the import Of course the macro can be tweaked.fine tuned but see if this works for you Maybe test with about 5 links first before going to

$$Excel-Macros$$ Urgent required Java/ Integration Architect - Seattle, WA

*Please respond to gurjant.si...@damcosoft.com * *Position: Java/ Integration ArchitectLocation: Seattle, WADuration: 6-12 Months, long term* Requirements/Skills: * Total 10+ yrs experience & telecom billing domain knowledge * Deep functional understanding of Order Management

Re: $$Excel-Macros$$ - merge and pivot excels

Okay Pramod.. first of all Thanks for your quick response. I assume below is the help you needed to move forward on this topic. - There are 35 to 40 excels in similar format i receive every day - I want only ID wise summary and activity wise summary from second sheet needs to be consolidated from

$$Excel-Macros$$ How to learn VBA or MACORS myself at home???

Dear All, Good day to you I am here with a small request, is there any way to learn basics of VBA , since am not good in VBA or MACROS Is there any books available to learn VBA myself at home ?? like how to use it ?? or what is formulas or syntax using for a conditions ?? please help me i a

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

Slaying Excel Dragons by Mike Girvin is a good book. I still can't figure out all the language stuff. But what helped me was recording marcos doing simple stuff, (ex renaming sheets, sorting data, etc) then stepping into the marco and I could see what its doing, which helped down the line when I

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

Dear Delin, Please try below link. http://www.excel-pratique.com/en/vba.php Its a very useful and simple . Enjoy Team XLS On Mon, Jul 14, 2014 at 10:56 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS wrote: > Dear All, > > Good day to you > > I am here with a small

$$Excel-Macros$$ Re: How to direct multiple hyperlink ?

Dear Experts, Any update on this. Thanks. From: Nitya Date: Mon, Jul 14, 2014 at 5:17 PM Subject: How to direct multiple hyperlink ? To: excel-macros@googlegroups.com Dear Aii experts, Please help in my query!! Please find the attachment explained clearly. How to direct multiple hyperlink ?

Re: $$Excel-Macros$$ Re: How to direct multiple hyperlink ?

Hi Nitya, Please find the Attached file. As per your requirement.. Hope This will fine for you. Warm Regards Pramod Bisht On Tue, Jul 15, 2014 at 9:23 AM, Nitya wrote: > Dear Experts, > > Any update on this. Thanks. > > From: Nitya > Date: Mon, Jul 14, 2014 at 5:17 PM > Subject: How to dir

Re: $$Excel-Macros$$ Re: How to direct multiple hyperlink ?

Perfectly working, thank you Pramod sir and victor sir. Thanks to all experts. Regards, Nitya On Tue, Jul 15, 2014 at 11:19 AM, Pramod Singh wrote: > Hi Nitya, > > Please find the Attached file. As per your requirement.. > Hope This will fine for you. > > > Warm Regards > Pramod Bisht > > > On