I have a large datasheet where AA9 to AA1200 have cells (Not all Cell currently have Value)
I have directory E:\Bill\ where the pdf is located.
The cell value and the pdf file name are the same.
If the Cell value is matched with the pdf file name then the cell value creates the hyperlink.
If nothing matched then skip.
If New file is created and a new entry is made in between AA9:AA1200 then auto-matched & creates the hyperlink.
Any help will be appreciated.
Thanks in Advance.