Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a purchase order log in Excel?
I have a Purchase Order form on Excel. I want to export or link the
"Supplier", "Job Number" and "PO Number" to another Excel spreadsheet. I want it to automatically List each PO in descending order by PO Number. If this is possible and I can get it set up, I then want to link the info to another spreadsheet sorted by "Job Number" and then by PO Number. Is any of this possible? I'm using Microsoft Office Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a purchase order log in Excel?
John,
This is possible. List your PO's in descending order (automatically), would require some VBA, but it is not a huge undertaking. -- http://HelpExcel.com "John W" wrote: I have a Purchase Order form on Excel. I want to export or link the "Supplier", "Job Number" and "PO Number" to another Excel spreadsheet. I want it to automatically List each PO in descending order by PO Number. If this is possible and I can get it set up, I then want to link the info to another spreadsheet sorted by "Job Number" and then by PO Number. Is any of this possible? I'm using Microsoft Office Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a formula to create an ordered purchase order | Excel Worksheet Functions | |||
how to create automatic purchase order numbering | Excel Discussion (Misc queries) | |||
Creating Purchase Order on Excel | Excel Worksheet Functions | |||
purchase order counter in excel purchase order template | Excel Worksheet Functions | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel |