LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I recover an Excel document saved not saved as Darryl Excel Discussion (Misc queries) 6 January 5th 10 03:39 AM
Copying cells from one sheet to another Andrew Excel Worksheet Functions 4 September 24th 09 05:19 AM
Document Not Saved HMH Excel Discussion (Misc queries) 2 May 9th 08 11:13 PM
Link Excel S/Sheet cells to Table in Word document Chris Gorham Excel Discussion (Misc queries) 2 January 20th 08 08:13 PM
copying cells to another document Jeffries'' Ex Excel Discussion (Misc queries) 1 August 1st 05 07:36 PM


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"