Simple one I hope????
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 |
Simple one I hope????
|
Simple one I hope????
If your data are organized properly as a list you can use a pivot table report
"Kev" wrote: 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 |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com