- Joined
- Apr 26, 2010
- Messages
- 31,116
- Reaction score
- 13,495
- Points
- 25,965
- Age
- 34
- Location
- Norkem Park, Gauteng
Let me start by showing the approximate layout of the spreadsheet:
Category is not important for this - it is merely for ease of navigating that sheet when adding/editing data.
What I need to do is in another sheet have the following:
Blue text is just to explain what's happening, red is all filled in dynamically from the first sheet based on the selections in the dropdown menus. Can anyone help with this? I've Googled, but it's a bit beyond me.
The final layout is quite important, so pivot tables are out of the question.
Category is not important for this - it is merely for ease of navigating that sheet when adding/editing data.
What I need to do is in another sheet have the following:
Blue text is just to explain what's happening, red is all filled in dynamically from the first sheet based on the selections in the dropdown menus. Can anyone help with this? I've Googled, but it's a bit beyond me.
The final layout is quite important, so pivot tables are out of the question.