Hello.
I have this problem.
I have two workbooks. One that collects info from many other workbooks.
The problem is that I want the first workbook to get information from the other workbooks only if the workbooks has been saved during the current date.
I have one cell in each of the several workbooks that contains the last date the workbook has been saved. (L1)
I want something like this to happen:
"If L1 in workbook 18 is todays date, copy cell A1-G1:A15-G15 to workbook number 2, else do nothing."
Is this possible to do?
/Anders
Bookmarks