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.

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
(E-Mail Removed)



"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.