Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Car make model list Results

Hi everybody. I'm new to the forum, and to programming in general.

I have a project I'm working on for school that simply takes vehicle registration data from a userform and puts it into a searchable database in excel.

I have no idea how to create a make/model/year list, like those you see on carfax or auto parts websites. Am I correct in calling those dynamic data validation lists?

Is there some sort of code that I could find somewhere and adapt to my purpose, or am I absolutely going to have to create one from scratch? If so, is there a good source on how to do so?

Thanks very much in advance,
Casey

Hi,
I need to link 2 dropdown lists in excel.
here is the scenario: I have 2 columns called car make and car model; each cell under these 2 columns are dropdown lists. if I select "honda" in the car make dropdown list, I want to see in the car model dropdown list only those models belonging to honda; all other models belonging to the other car makers should not be selectable.

Can anyone help me with this ??

Thank you

marius

I apologize if this question has already been answered, but I am new to excel terminology.
In my work book, on sheet 3, A1 I have a list of car makes and sheet 3, A2 I have car models. For instance when I click on A1, I can click on Buick and A2 List will show the car models for Buick and the same for other make and models.
I need to get these two lists on a different worksheet (same workbook) called StorageLots.
sheet 3, A1 to be put on sheet called SorageLots L2
sheet 3, A2 to be put on sheet called StorageLots M2
Data validation source for sheet 3, A1 source is =Make1 and
data validation for sheet 3 A2 is =INDIRECT(SUBSTITUTE($A$1,"","_"))

Thanks so much.
Perkins91

I apologize if this question has already been answered, but I am new to excel terminology. In my work book, on sheet 3, A1 I have a list of car makes and sheet 3, A2 I have car models. For instance when I click on A1, I can click on Buick and A2 List will show the car models for Buick and the same for other make and models. I need to get these two lists on a different worksheet (same workbook) called StorageLots. Sheet 3, A1 to be put on sheet called SorageLots L2, sheet 3, A2 to be put on sheet called StorageLots M2. Data validation source for sheet 3, A1 source is =Make1 and data validation for sheet 3 A2 is =INDIRECT(SUBSTITUTE($A$1,"","_"))

Hi,

I have on each row details on cars. Name, make, model, top speed, etc. This is too long to reasonably use effectively.

What I want to do is be able to select a cell on the master row and have a list of options for different cars. Once the value is selected from that cell it automatically fills in all the other details.

How can I do this in excel?

Hi,

Ok my problem is i trying to find out if possible to use a list which will pull information about the item selected. For example i have the below information in Sheet 1 and in Sheet 2 i have a list whith the car makes in A1. Now when i select the car make i want the color & make to appear also but in different cells on Sheet 2.

Example:

A / B / C

make / color / model

bmw / silver / S300
vw / red / rabbit
mercedes / black / S400

How can I use pull down lists to filter data. For instance I have a
spreadsheet of 100 different cars of various makes/models. I want to use
the first pull down menu to filter out all of the Chevrolets. The next pull
down will show the results of the first pull down. where I can select one.
Is this possible?

Hi there,

I am trying to perform a substitute on a list of car makes/models and wish to substitute a hyphen on several Mercedes-Benz models.

It isn't as simple as it sounds because if i do substitute(CELL, "-Class", "Class") it performs the function on other models I don't require to be substituted.

What I had thought was I could do: substitute(CELL, "Mercedes-Benz/?-Class", "Mercedes-Benz/?Class"). However this isn't working. I need to perform it on several models with the same style and just can't work out how to do it.

Any help will be fantastic. Thanks!

David

HEllo

im making a spreadsheet to look up different car part prices for different car. What i am trying to do is this,

i have a cell called make which has a drop down list of car makes. I have another one called model which depending on what make you choose will populate a drop down list with relevant models. For example if you select ford from the make list then you will have a list in the make cell with fiesta, escort, modeo etc etc. In the next cell is a drop down list of different car part suppliers. I can do all this but this next bit is where im stuck. I have another cell with the heading parts, once you have selected the car make, model and the parts supplier you want, I want the cell to be popluated with a drop down menu with all the parts avaliable for that car by that supplier.

The info for each supplier will be stored in a seperate work book to save file size

Can this be done?

Okay, I'm wanting to have two different lists that are created from the
validation tool, but one is dependant upon the other.

For example, the best example I can think of is car makes and models. In
one drop down list, I want a list of car makes. In my secondary list, I want
a list of all the models based on the make selected. Does this make sense?
You'd select the first drop down list and select "Honda", and then the second
list automatically updates with "Accord", "Civic", etc. for my selction.

If you have any thoughts, I'd really appreciate it! If you need more info,
also, just let me know!

How can I use pull down lists to filter data. For instance I have a
spreadsheet of 100 different cars of various makes/models. I want to use
the first pull down menu to filter out all of the Chevrolets. The next pull
down will show the results of the first pull down. where I can select one.
Is this possible?

How can i make a validation list that is dependant on a value in a cell from
another validation list, for eg I choose the make of a car from a list then
the list next to that changes to the models of that particular make of car,
is this possible and if so please could you enlighten me

Hello,
I'm in a bit of a pickle (as I'm sure most people making requests here are),

Thus far about 8hrs of tutorials has passed by, and this is the last project I want gnawing on my time during the Christmas holidays.

I happen to be an owner of a very ugly customer spreadsheet. Due to the nature of the information, there will always be large blank holes, missing data, or old data that shouldn't be removed.

The spreadsheet is layed out as such:
(I will use cars & houses as examples to hopefuly make it clearer)

------------
Column A : List of client names

Column B : denotes the status of the client's data regarding their car: up to date, old, or none available

Column C-F : Attributes of the client's car (colour, model, etc.)

Column G : denotes the status of the client's data regarding their house: up to date, old, or empty

Column H-k : Attributes of the client's house (bedrooms, mortgage, etc.)
------------

Sometimes a client has more than one car or house, which so far takes up an extra line of entry one line below. This results in the clients list containing blank spaces.

Sometimes a client doesn't own a car or a house.

I'm trying to configure this setup in such a way that if I select a particular client from drop down menu (such as data validation lists), their information will be displayed along side it.

So if I selected client 'Chuck' from the client list, I would see only information pertinent to his car / house.

I hope to find a solution to this,
And innumerable thanks to anyone that took interest and read this far.

Happy Holidays,

-Cheshire

Hello,

I've got a quick question regarding resetting drop down menus when a user changes their selection in the GUI. What I'm trying to do it create a top level drop down menu that opens up other drop down menus depending on what was chosen. When the user changes the top level selection, i'd like it to clear the contents of all the pre-populated cells that came about as results from the initial drop down selection.

In the example I included, I jinned up a BS example but emulates the exact goal/problems I am having with the workbook im trying to write.

In the example I created three groups, car manufacturers in this case: Ford/Chevy/Jeep.

Each of these groups has three vehicle models that can be chosen (Ford: F150/Tauras/Ecoline, Chevy: Silverado/Volt/Camero, Jeep: Wrangler/J100/Cherokee). All arbitary, just something to emulate my problem

The yellow column on the right is how the user would make their initial selction, in this case which manufactuer and was handled with a Data Validation "list" dropdown menu. Per each manufactuer selection, blue cells can then be selected with options available based on which manufactuer. This was handled by declaring each model list as a group name and using the =INDIRECT() fnc to reference them back to the manufactuer. This all seems to work correctly thus far.

What Im having trouble is the reset of the model's when the user changed the manufactuer. Obviously, if the user were to change the manufactuer from Jeep to Ford he wouldn't expect to see a Wrangler or Cherokee as an availabe option so these need to be reset. I've been tackling this through some VBA scripting where I have placed conditional statements on the cell selections and using the .ClearContents fnc for Models A/B/C. This works to a degree...

Sometimes the models will reset if the user changes the manufactuer from one to another, sometime they dont. Other times they do nothing and if another manufactuer is chosen above or below said manufactuer it will reset the last one if they are the same manufactuer or sometimes clear out another of the same manufactuer. It's all rather speriadic and very confusing and I can't help but think that I'm missing something very trival here.

If anyone has any idea what might be casuing this or could take a look at my example code, I'd really appreciate it. It's been years since I've worked with VBA and I've been at this for the better part of the afternoon. My ideas are runing thin!

Been awhile since I last visited. I would appreciate a helping hand. I have the following situation:

I keep a spreadsheet (mainsheet) that lists all the pertinent Data for my inventory. It is sorted by make, Model, and year of the car. Each car has a stock number that is unique.

Every day the accounting department updates a proprietary accounting system and therefore my costs change daily. The accounting system has a function that I can manually export to an excel spreadsheet some very basic data. What I want to do is to write a macro in my spreadsheet that compares the stock# data in the "mainsheet" to the stock# data in the manual sheet and, if it is a match cut and paste the cost data to the mainsheet.

Hi All,

This is my first time posting here but i was hoping someone here could point me in the right direction with a problem I am having, I have tried googling and have come up with nothing (although this might be more of a reflection on my lack of knowledge of excel terminology).

Here is what I am trying to achieve:

I have a workbook with two tabs, on the first one there is one column and the top of the column(A1) is a dropdown containing the options 'Boy' or 'Girl'.
One the second worksheet I have two named tables (Boy and Girl) - these tables each contain a single column array with 5 names in each (so we have a table of 5 boys names and a table of 5 girls names)

What I want to happen is when a user selects an option from the dropdown in A1 the cell below(A2) is populated randomly with a name from the corresponding list.

I have achieved this initially using the following formula:
=IF(A1="Boy", INDEX(Boy,RandInt(1,10)), INDEX(Girl,RandInt(1,10)))

This works fine, but I will need to expand this for several dropdown options, so my new workbook will have a dropdown of car makes, and each make will have a list of the models associatied with the car make (e.g. Ford: Fiesta, Escort, Mondeo...)
But I do not want to have a ridiculously long nested IF statement for every car Make, so what I want to do is something along the lines of the following:

=INDEX([CONTENTS OF A1],RandInt(1,10))

So I use the text selected from the dropdown in A1 as the TableName in my formula - however, I cannot retrieve that to use in the formula without it coming back as a text with the "" included and my formula errors! any ideas??

Thanks in advance guys, hope everything is clear enough!

Rob

Hi all, i tried searching how to do it on previous threads but i did nto have the technical understanding of all the jargon used so i'll be very specific with what i need and i kindly request that you all reply in very simple english plzzzz Thankyou!

I am constructing a database in EXCEL for cars and car loans etc. Now i would like to make a drop down list in lets say cell A1 with the title 'Manufacturers' and when you click that cell you can select from a drop down list of manufacturers listed (I've accomplished this step so no need to explain to me how to do this). My next step is making another cell beside it with the title 'Models' (Say its in cell B2) where i want the list to only show the model of cars for that particular manufactuer. FOR EXAMPLE. In cell A1 i select 'Holden' from the drop down list (This list contains Holden, Volkswagon, Subaru and Honda) then in cell B2 i want ONLY the holden models to appear in that drop down list (Monaro, Commodore, Barina etc). But, IF i select Honda, i want cell B2 to only have the Honda models to choose from (Accord, S2000, Civic etc). I hope what im asking for is clear cut and that you all understand me? If its not too much too ask could you please present me with a step by step list. Ive tried to understand the VLOOKUP's and HLOOKUP's etc but i have no clue what they're about and if they even relate to what im asking . I feel like im on the right track but im missing some simple function to relate these two drop down bars?
Sorry if i sound like a complete id10t or if this answer has been posted before (I read through a few other posts but lacked the understanding)

HELP PLZ (p.s. i use both EXCEL 2003 and 2007 edition so explain in either format its ok) thanks

I am trying to create an inventory workbook for the company I am working for. I want my UserForm to work like when you go to cars.com and have one list to select make, then the next list is filtered based on that value and you select the model, then the other list selects the trim and I was wondering how you would do that. I eventually want to make it so you can take something on and off inventory with this UserForm. I am going to have trailers, bobcats, forms, trucks, etc.... that will be in and out of use.

Any ideas? It is a lot to digest and just the tip of the iceberg.

Well, at least it seems a bit tough for me. I know you guys are the best of the best here so i come on bended knee for help...(enough with the crap i know).

This is basically what I need to get done and I have an idea on what to do and can get it done if needed but there has to be a faster way of getting it done.

I am going to have a list of "static modifiers" which I wish to expand through each other in every possible combination. I work with advertising on the internet and we deal with cars so:

"lease" modifier------word "new"------Auto Type------Make------Model------State------City

Now each column (defined in between the dashes) will have a list underneath. For instance State will have all 50 underneath, while city will have (corresponding to the state for each sheet) all the major metro areas or cities. Make and Model will have all makes and all models we deal with and auto type will be broad terms such as: car, truck, van, etc. Lease will be all the variations we have of that searched word. This is just to help you get an idea of what im doing.

With this i need to expand the list, with all the variations possible. For example:
lease new car
lease new truck
lease car
lease truck
lease new car in Florida
lease new truck in Florida
lease car Florida
lease truck Florida

and it keeps going:
lease Ford
lease Ford truck
lease Ford car
lease Ford in Florida (the adding of the "in"s and "a"s are another issue)
lease Ford Mustang in Florida

and so forth...I did it in no particular order, but i hope you get the picture as to what im trying to do.

Now I do not have the list of words yet, this master list but I was wondering if there is a function or macro I can use with just knowing that these 7 columns need to be mix and matched into every possible combination.

Thanks so much guys...

You know like how when you go to a website and you choose the type of product it shows you only possible choices for said product. For example you have are buying a car and you choose Make Dodge, then you are shown models for Dodge, after you choose the model you then are able to choose year.

Is there anyway to do this in excel? Doesn't have to be a listbox but if it is a combo box the user should not be able to change the data.

Also the scroll bar, how do they work? Lets say I have listbox1 and want scrollbar1 to move listbox1, is that how it works or what?


No luck finding an answer? You could always try Google.