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.
