View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
a94andwi[_3_] a94andwi[_3_] is offline
external usenet poster
 
Posts: 1
Default Copying cells from one sheet to another if document has been saved.


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


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=384465