department store

[ahhhmed]

Assume I have a department store. I like to make an excel sheet to view all the items on the store. What I need to have is a set of option buttons:

1- first button is to select store - garments, shoes, hats, children clothes, etc.

2- 2nd button is to select type of goods

then when I select certain items I want information to be displayed like quantity and price.

 

[vasim]

Is the second option button type of goods - fixed.........

 

[Luke M]

ahhhmed,


How easy this report will be to create depends on how well your data is setup. Does your data table have a column already with the different store types? Different good types?


If so, I'd recommend either setting up a PivotTable (easy, fast, but not very customizable if you need charts). Using buttons and toggles is possible, but it'll take a good amount of coding to factor in each different type of scenario. Can you please elaborate on what you have (and what you really want to end up with)?

 

[ahhhmed]

buttons is what I need because i want my spreadsheet to act like Access 2007.

 

[vasim]

Ahhhmed, are you sure you want option buttons or drop down box/list for both. As there are multiple items a drop down box would be more reasonable.