Dear Sir, I ran your code, but nothing happened. Any way than you sir for your help. Dear Sir, Is it possible to develop custom function
with four inputs (path name, file name, sheet name, cell name ) to get relevant data value according to the date and hour. I attached
sample master sheet herewith. In that column Column C contain path name, column D contain file name, column E contain Sheet name, columns F,G,H
contain Cells name. So it is possible to write function (getdata) with columns C,D,E,F as input to get value for column I

http://www.mediafire.com/download/0r...xi/Master.xlsx
again Thank you Sir for your kind help

ueranda