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.


By: amey

Leave a Reply

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