View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Simple one I hope????

More info on your layout??

--
Don Guillett
SalesAid Software

"Kev" wrote in message
...
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