Simple one I hope????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel Purchase order form with a drop down menu with 3 options -
Credit card
Account
Other
My problem is that when i look at a list of all the saved Purchase order
files i need the option to be able to sort them by those with C/C, Account or
Other.
I really thought that creating a custom Property and linking it to a cell on
sheet2 that is =C17 where the drop down menu is would sort this out.
When i chech the custom properties of the Purchase order files this seems to
be working.
My problem is i dont seem to be able to seperate the files into three
relevent groups.
Does any genius out there know of a way??
Eternally gratefull,
Kev
 
If your data are organized properly as a list you can use a pivot table report
 
You must log in or register to reply here.

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

I need to display the text from one cell in another. 2
Extracting info from one col. and combining it with a simple formu 3
is it possible to enter in text over a formula without deleting the formula? 3
how do I control the sort order of a filter in a pivot table? 1
How do I link one cell to a range of cell with a drop-down menu? 2
Simple way to combine unmatched and matched records in one query? 6
copy doument names from a file into excel 6
Can I make an order form on an office application? 2

Back
Top