| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I link purchase order dates from one excel workbook to ano.
I am an expeditor. I update on a daily basis an excel report with open
orders which the Purchase Order Number, Line Number and date shipped. I also receive a Recieving Report on a daily basis which I have to manually update the dates of Purchase Orders that are received. I would like to pull the updates from the receiving reports into the Open Report. Is there a way I can do that? Please let me know. I am using Microsoft Excel 2003 |
|
#2
|
|||
|
|||
|
See the section on Vlookup formulas
http://www.datapigtechnologies.com/ExcelMain.htm HTH "LeLe123" wrote: I am an expeditor. I update on a daily basis an excel report with open orders which the Purchase Order Number, Line Number and date shipped. I also receive a Recieving Report on a daily basis which I have to manually update the dates of Purchase Orders that are received. I would like to pull the updates from the receiving reports into the Open Report. Is there a way I can do that? Please let me know. I am using Microsoft Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
| Why won't it Excel fill in weekly dates now, changes them to daily | Excel Worksheet Functions | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
| purchase order counter in excel purchase order template | Excel Worksheet Functions | |||
| Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) | |||
Linear Mode
