View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
galimi galimi is offline
external usenet poster
 
Posts: 210
Default 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.