|
|
|
|
#1
10-09-2015, 07:37 AM
|
|||
|
|||
You may be able to keep this always current with a vlookup formula.
A VBA suggestion would be to loop through the serial numbers of one sheet Use match or find on the other sheet Offset to get the date Datediff to get the delta. A better answer could be provided if you actually do attach a sample workbook. 
|
|
#2
10-12-2015, 02:32 PM
|
|||
|
|||
|
Sorry, thought I had.
Sorry, thought I had.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy data from one form to another | jodjamz | Outlook | 0 | 04-28-2015 05:07 PM |
| Copy data from certain Cells in new sheet | zain_shaikh | Excel Programming | 1 | 02-11-2015 07:35 PM |
| Copy data from Word into Excel | chinchee | Word VBA | 18 | 05-23-2014 05:25 AM |
| How to copy data automatically to particular sheet? | nicholes | Excel Programming | 13 | 03-12-2014 01:05 AM |
 Copy data from spreadsheets to a two, with the sum criterion
|
marreco | Excel Programming | 1 | 05-15-2012 04:15 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode