Yah this can be done.... I am busy right now .....when I have time I must solve this one..
Pramod On 16 Jul 2014 12:37, "Nitya" <nityanandadole...@gmail.com> wrote: > Dear Pramod sir, > > Can we get the link in exel too. I mean if the link data is pulling the > data from web, than the same link should be capture with respect to its > row. > and than loop to next link, same the running link should be pasted in its > respective rows till all the link is completed pulling data. > Please refer below table: In End of the column there is link. Can it be > done sir. > > Date HS Code Description Origin Country Port of Discharge Unit > Quantity Value (INR) Per Unit (INR) Link 28-Jun-14 84433290 > C31C598256/C5982560030 > TM-T81-256: BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 168 > 9,53,013 5,673 https://www.zauba.com/import-tm t81 printer > pos-hs-code.html 28-Jun-14 84433290 C31C598256/C5982560030 TM-T81-256: > BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 336 19,06,027 5,673 > https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-Jun-14 > 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN > CHINA China Chennai Sea NOS 336 19,04,160 5,667 > https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-Jun-14 > 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN > CHINA China Chennai Sea NOS 168 9,52,080 5,667 > https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-Jun-14 > 84433290 C31C598254/C5982540030 TM-T81-254: BOX PRINTER FOR POS MADEIN > CHINA China Chennai Sea NOS 168 9,53,172 5,674 > https://www.zauba.com/import-tm t81 printer pos-hs-code.html 23-May-14 > 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN > CHINA China Chennai Sea NOS 336 17,16,988 5,110 > https://www.zauba.com/import-tm t81 printer pos-hs-code.html 12-May-14 > 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN > CHINA China Chennai Sea NOS 336 17,45,175 5,194 > https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-May-14 > 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN > CHINA China Chennai Sea NOS 336 17,22,127 5,125 > https://www.zauba.com/import-tm t81 printer pos-hs-code.html 05-May-14 > 84433290 C31C598256/C5982560030 TM-T81-256: BOX PRINTER FOR POS MADEIN > CHINA China Chennai Sea NOS 168 8,61,063 5,125 > https://www.zauba.com/import-tm t81 printer pos-hs-code.html Date HS > Code Description Origin Country Port of Discharge Unit Quantity Value > (INR) Per Unit (INR) https://www.zauba.com/import-tm T82 printer > pos-hs-code.html 28-Jun-14 84433290 C31CD52354/CD523540130 TM-T82II-354 > BOX PRINTER FOR POS MADEIN CHINA China Chennai Sea NOS 27 1,69,146 6,265 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html 12-Jun-14 > 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN > CHINA China Chennai Sea NOS 53 3,31,702 6,259 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html 12-Jun-14 > 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN > CHINA China Chennai Sea NOS 80 5,00,683 6,259 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html 05-Jun-14 > 84433290 C31CD52352/CD523521030 TM-T82II-352: BOX PRINTER FOR POS MADE IN > CHINA China Chennai Sea NOS 144 9,02,263 6,266 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html 29-May-14 > 84433290 C31CD52353/CD523530130 TM-T82II-353: BOX PRINTER FOR POS MADE IN > CHINA China Chennai Sea NOS 20 1,21,261 6,063 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html 25-Apr-14 > 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN > CHINA Hong Kong Chennai Sea NOS 44 2,38,487 5,420 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html 25-Apr-14 > 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN > CHINA Hong Kong Chennai Sea NOS 97 5,25,755 5,420 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html 04-Apr-14 > 84433290 C31CD52354/CD523540130 TM-T82II-354: BOX PRINTER FOR POS MADE IN > CHINA Hong Kong Chennai Sea NOS 81 4,30,271 5,312 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html 04-Apr-14 > 84433290 C31CD52352/CD523520130 TM-T82II-352: BOX PRINTER FOR POS MADE IN > CHINA Hong Kong Chennai Sea NOS 25 1,32,800 5,312 > https://www.zauba.com/import-tm T82 printer pos-hs-code.html > > > Thanking you > Regards, > Nitya > > > On Tue, Jul 15, 2014 at 12:10 PM, Nitya <nityanandadole...@gmail.com> > wrote: > >> 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 <pramod...@gmail.com> >> wrote: >> >>> 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 <nityanandadole...@gmail.com> >>> wrote: >>> >>>> Dear Experts, >>>> >>>> Any update on this. Thanks. >>>> >>>> From: Nitya <nityanandadole...@gmail.com> >>>> 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 ? >>>> >>>> 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 example >>>> After every table pulled , there should 1 row blank and than continue >>>> copy paste from next row. >>>> >>>> I got some macros from website please find below, this macros works for >>>> only 1 link, but I want for entire link in left side. There can be more >>>> link say 80-100 link >>>> Please refer Module: >>>> >>>> Thanking you all >>>> >>>> Regards, >>>> Nitya >>>> >>>> >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros+unsubscr...@googlegroups.com. >>>> To post to this group, send email to excel-macros@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> *PramodSingh* >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
