How do I create a purchase order log in Excel?

J

John W

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

galimi

John,

This is possible. List your PO's in descending order (automatically), would
require some VBA, but it is not a huge undertaking.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Counting Occurence of identical order numbers 3
Excel Excel: Match, Index and subtract across 2 columns and 2 tabs 2
Purchase order 2
auto numbers 1
Add numbers belonging to a vendor 4
Auto-Alphabetize 1
How to insert macro results on a separate spreadsheet in row order 1

Top