rbv
02-03-2017, 03:57 AM
Dears,
Could you please help me?
I have excel file where i extract daly values from SQL. For each value is column F there is a "Batch number" in column Q.
For each "Batch number" I have to add in "column R" and hyperlink to connect to the pdf related to the "Batch number"
I am doing it manually, and it's time consuming in case we have many "batch numbers"
The batch number are for example : 775533 and the pdf ( which is saved on L: Drive ) have automatically the name "******x_"775533"_***xx".pdf. Where the "***xx" are text.
Ps: the batch number changed based on cell. ( it should be kind of vlookup) seach for batch number and catch the pdf.
( as per below)
batch Number Link
(column Q) ( column R)
line 1 - 775533 "***xx"775533"***x"
line 2 - 889922 "***xx"889922"***xx"
line 3 - 664411 "***xx"664411"***x"
.....
.....
Is there a away how we could do it automatically?
many thanks for your help
Could you please help me?
I have excel file where i extract daly values from SQL. For each value is column F there is a "Batch number" in column Q.
For each "Batch number" I have to add in "column R" and hyperlink to connect to the pdf related to the "Batch number"
I am doing it manually, and it's time consuming in case we have many "batch numbers"
The batch number are for example : 775533 and the pdf ( which is saved on L: Drive ) have automatically the name "******x_"775533"_***xx".pdf. Where the "***xx" are text.
Ps: the batch number changed based on cell. ( it should be kind of vlookup) seach for batch number and catch the pdf.
( as per below)
batch Number Link
(column Q) ( column R)
line 1 - 775533 "***xx"775533"***x"
line 2 - 889922 "***xx"889922"***xx"
line 3 - 664411 "***xx"664411"***x"
.....
.....
Is there a away how we could do it automatically?
many thanks for your help