Hello:
Please refer to attached file.
I have check box in column A cell I1:I2 and the result for check box is in cell I1:I2 as TRUE OR FALSE.
If I1 or i2 is TRUE then I need to fetch the 2 latest file name from directory as shown in K1:K2.
Example:
I have lots of file in C:\Store1\.
If I1 is TRUE then need to go to the directory C:\Store1\ and get 2 newest file and put the file name in L1 and M1
If I2 is TRUE then need to go to the directory C:\Store2\ and get 2 newest file and put the file name in L2 and M2
Let me know if you have any questions.
Thanks.
Riz
Bookmarks