hello
I have many files from XLSB extension in this directory D:\VOCHER and somtimes contains subfolders. so waht I want when run the macro should bring the values from of it . the last file depends on date created file when bring the values .
for instance the last file contains data as in first sheet
when run the macro from new file as in the second sheet should search for row19 in last file as in first sheet based on created date and brings just the value 123 and put this value in the beginning in cell D19 minus the values from N6 , the amount in N6 i will put it manually . should put this process in cell D19
as you see when calculate the values should be in the same cell D19 , if it's impossible then should put each value in separated cells in row 19
hope to be sense what I ask for it .
note: the first sheet represents the last file where brings the values from it . based on date created , the second sheet represent the new file should run the macro from it I put in one file into two sheet to see the result closely
thanks
Bookmarks