|
|
#5
05-23-2015, 10:02 AM
|
|||
|
|||
If Graham doesn't mind, and I follow what you're doing and I'm not sure I do...
You only need to use the Worksheet_Change event of the sheet containing the 4 dates. You will need to refer to the other sheets by their "code name" in order to always be working with the same sheet. Your dates must be entered manually or with VBA. They cannot be the result of a formula. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to fetch data from one sheet to another with complete details and date wise as well | harisjawed86 | Excel Programming | 1 | 08-05-2014 09:10 PM |
 how to automatically copy parts of a record to another sheet?
|
kmeechan | Excel | 1 | 05-28-2014 02:24 AM |
| How to copy data automatically to particular sheet? | nicholes | Excel Programming | 13 | 03-12-2014 01:05 AM |
|
How to automatically insert DAY instead of date?
|
kylera | Word | 3 | 06-28-2012 12:38 PM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode