Macro to replace data within a worksheet

  • Thread starter Thread starter Excell
  • Start date Start date
E

Excell

Trying to see if anyone has created a macro/form that enables a user to
select an item from a drop down list that will then populate the rest
of the form based on that selection.

Here's an example: Say you're buying a new car and you'd like to be
able to select all of the options associated with a particular model.
If you selected Model A from a drop down list then the rest of the
worksheet would be populated with options relating to that model.
Likewise, if you selected Model B from the drop down list other
information would be populated.

I'm stumped. Any help would be appreciated.
 
This sounds like a job for the VLOOKUP function..........check it out, and
if you need more specific help, post back.

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - Conditional List 3
MS excell 2007 Data verification list 1
Lookup a reference, go to another worksheet, retrieve a block of d 2
Import data from 1 cell on 1 worksheet to othr cell(s) in another 1
Excel Custom trendlines and R^2 values 0
Pasting cell contents into a macro 1
How do I create a spreadsheet that populates q's from a drop down 3
Drop down box issue 2

Back
Top