Hello Everyone!
First, I would like to apologize if I'm posting this in the wrong section of the forum.
Having said that, I'm taking on a new project in which I need to create an interactive spreadsheet that will eventually be converted for the web. How I'm going to achieve the latter is something I'm not concerned with at the moment. What does concern is how this spreadsheet will come to be.
Unfortunately I'm not an Excel expert, otherwise I wouldn't have ended up here. But I am a fast learner so I hope to learn a lot from knowledgeable people on this site
By the way, I searched the web quite a bit to find a solution but there was a lot of information and I wasn't sure what method to apply.
At any rate, what I'm trying to achieve is simple to explain. Let me give you an example:
> I have a list of cell phones.
> Each cell phone will provide three pieces of information: what carrier, how much storage space, and how many there are in stock.
> The cell phones should display in a list.
> Upon selecting a cell phone, the row should auto fill with the respective information of each cell phone (assuming across three columns).
So if someone from the list chooses HTC HD2, the results should be displayed in the following manner:
B2: HTC HD2 > C2: T-Mobile > D2: 16 GB > E2: 26
I hope I have made this clear enough.
I have seen people talk about several ways of doing this but I'm not sure how and what to implement. Do I bring Access in the mix? Do I use VBA? I just don't know how to get started.
I hope you guys can help!
Bookmarks