If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importin updated dates from another spreadsheet
How do you import dates from one spead sheet to another?
The cells are in different locations but have the same names. on the left is ID and on the top would be the deliverable good. Between would be the actual date recived. |
#2
|
|||
|
|||
Depending on your needs, one of these methods ought to work:
Copy-Paste (maybe Paste-Link) VLookup Index(range,Match(X,Xrange),Match(Y,Yrange)) where range, X range, and Y range are on the source sheet and X and Y are headers on the target sheet X might be ID and Y might be the deliverable good - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sean wrote: How do you import dates from one spead sheet to another? The cells are in different locations but have the same names. on the left is ID and on the top would be the deliverable good. Between would be the actual date recived. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change Start Dates without Changing Due Dates | Beth | General Discussion | 0 | August 19th, 2004 03:44 PM |
multi-user lockout of linked excel spreadsheet | Tim Schiermeyer | Setting up and Configuration | 0 | November 15th, 2003 01:56 AM |
multi-user lockout of linked excel spreadsheet | Tim Schiermeyer | Links and Linking | 0 | November 15th, 2003 01:56 AM |
subtracting dates to give a whole number | Lasitter | Worksheet Functions | 2 | October 1st, 2003 09:14 AM |
Sum Dates | SFrick | Worksheet Functions | 3 | September 18th, 2003 12:26 PM |