What's new
Carbonite

South Africa's Top Online Tech Classifieds!
Register a free account today to become a member! (No Under 18's)
Home of C.U.D.

Excel Help Needed

Oj0

Progenix.co.za
Retailer
VIP Supporter
Rating - 100%
245   0   0
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:

WUB7fav.jpg



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:

lK6XbOE.jpg



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.
 
Let me start by showing the approximate layout of the spreadsheet:

WUB7fav.jpg



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:

lK6XbOE.jpg



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.

I don't see dropdowns. What is supposed to happen when you change the dropdowns?
 
First thing with Excel, your main data (your main sheet) Musn't contain formatting.

You want it as raw as possible so you can manipulate it as you see fit.

This will then also allow you to do a Hlookup and populate the fields, you can also great a drop down menu with the Configs pre-defined if you want.

But start with removing all the formatting on that sheet, or create a copy of it and remove the formatting. send me a PM if you need guidance and could possibly work you through it on discord etc.
 

Users who are viewing this thread

Back
Top Bottom