Cell Value fetch from file with date

Have 1 folder (HERO) with Multiple files of name ABC-YYYY-MM-DD.xlsx

(E.g ABC-2018-10-01.xlsx, ABC-2018-10-02.xlsx, ABC-2018-10-03.xlsx etc…)

 

Having Master Xcel file where in A column is having date

Against Every date I need value of cell_B4 of file available in HERO folder with same date.

E.g:

Example

 

By: Acekhan

Leave a Reply

Your email address will not be published. Required fields are marked *