a folder containing excel (named validation) with a table containing names (alpha, echo, roger).
what i want is- once i work on each files (alpha, echo, roger) and place it in that folder – the formula should detect the file name with date and pickup data from a particular cell from a sheet.
So, in my Validation excel – once i place ALPHA file with cell containing a Figure,
Validation file should pick that Figure from ALPHA file.
like wise for other sheets.