Importin updated dates from another spreadsheet

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

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.
 
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/
_______
 
Back
Top