information help: ms excell arghhhh - Help.com



This post left anonymously

ms excell arghhhh

hi guys,

ive just been given a task to design a table using ms excell. its meant to have drop down menus, and if i click on an item from within the drop down list, it should come up with a separate table with more information about the item. so, for example, if in the main table i would be finding out a type of vehicle eg. sports car) and amount sold, whereas if i clicked on the the ’sports car’, it should come up with a list of makes (eg. bmw). when you click on one of the makes, a new table will appear with the model, who it was sold to and date etc.
is that possible? if so, does anyone know how to go about it?
any help would be most appreciated.

This open post was written 1 year, 2 months ago | V/U/S: 117, 1, 2 | Edit Post | Leave a reply | Report Post


Reciprocity (0) Reciprocation Failure -- The poster has NOT helped anyone else yet!

Since writing this post Anonymous may have helped people, but has not within the last 4 days.

Post Tags (10)

BMW, automobile, information, Design, sport, vehicle, Quantity, Sports car, Main, model (How Tags Affect Reciprocity)

Replies (1)

Where were you?

Click and drag to move the map around. FAQ: How we place people on this map »
You can also watch events on Help.com as they happen
Mouse over the map for 2 seconds to see an expanded, interactive view

Firefly27 offline Verified User (1 year, 8 months) Long Term User Shouts: 0 #
Waldorf, MD, US | 1 year, 2 months ago (2 hours, 41 minutes after post)

It sounds like you might need something more like MS Access than Excel. With Access, you can make actual databases, which are alot more powerful than what you can do in Excel. You can have it run reports (which is what it sounds like you want to do) whereas Excel you can only really sort and filter.

Quote this reply Report this reply to moderators
Help me with: So, I just got an invitation to my 10-yr high school reunion.

Invite Others to Help

A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.