look for help with a PO log
 

could someone point me in the right direction please.

I am working on a spreedsheet that i can use for a po log. on the first
sheet i want to have a list of items (date, po number, name of vender,
cost and account number.) on the second sheet i need it to sort the
items by the account number and date and put all the like numbers
togeather and total them. then on the third sheet you will see the
monthly cost of each line item.


the part i don't know how to do is make the sheet sort by account
numbers.


thx
yarbor


--
yarbor
------------------------------------------------------------------------
yarbor's Profile: http://www.excelforum.com/member.php...o&userid=27458
View this thread: http://www.excelforum.com/showthread...hreadid=469741

Manually,
Data:Sort:(select the column and other options in that window)

yarbor Wrote:
could someone point me in the right direction please.

I am working on a spreedsheet that i can use for a po log. on the first
sheet i want to have a list of items (date, po number, name of vender,
cost and account number.) on the second sheet i need it to sort the
items by the account number and date and put all the like numbers
togeather and total them. then on the third sheet you will see the
monthly cost of each line item.


the part i don't know how to do is make the sheet sort by account
numbers.


thx
yarbor


--
midavis
------------------------------------------------------------------------
midavis's Profile: http://www.excelforum.com/member.php...o&userid=27475
View this thread: http://www.excelforum.com/showthread...hreadid=469741