![]() |
How to make a query menu?
This is what I want to make. I work for Kellogg's on a sales division. So I
have sales info (%shelf, %displays, etc), categories info (snacks, cereals, etc), geographical data (territories, city), store formats (walmart, etc) and time ranges. So I want to make a file where I store all this data, month to month. And then some wizard in excel in which you can select of all these info what you want to see, and it automatically sorts the data in like pivot table in such way and might show a table and a chart. I know this can be done because before I worked at PG and they did this. Someone can tell me which tools should I use? Any ideas? I need to learn how to do this! Thank you! |
All times are GMT +1. The time now is 02:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com