Free Microsoft Excel 2013 Quick Reference

Create a Sub List from a drop down list

I need to create a 'sub' list from a drop down list.
I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.

And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.


Post your answer or comment

comments powered by Disqus
Hi
I have no problem creating lists using Data validation and formulas...

i want to creat a sub list from a main list...
so when displaying an item from the main list, another sub list appear to show sub items that are linked to the main item in the main list

however, i wnat to use only one column, not two or three columns

yours
hesham

I have a spreadsheet where data will be input. Three of the fields consist of State, Month and Year. I would like to create a pick list or drop down list but I am a beginner at this and have no clue as to how to do this.
Does anyone have any suggestions or examples?

Thanks in advanced.
Klobb

I have a multi page workbook with items in different categories. I have created a sheet that pulls in any row that had a number in the ordered column. What I need now is a way to have another sheet create a pick list from the order sheet. I only need three of the cells in each row brought over but the cells in the pick list sheet are in different places than the order sheet. For example, on the order list I have columns A-G with headings for item#, description, price, etc. I only need to bring in the item#, description and number ordered to the pick list. Can someone please help me with the code for this? I've attached a small sheet that demonstrates what I have so far. Thanks in advance for any help!Test Order.xlsm

Hello;

1) Data validation in cell A1 allows a selection from a crowded drop-down list of about 30 items.
Most of the items on the list are lengthy technical descriptions, but they share some common keywords.

2) In order to speed up the selection from the A1 list, I would like to create a sub-list in cell B1 using some shared keywords, and use the selection to shorten the main list in A1.

3) Confusing ? Let me try a simple example.
Suppose A1 for this example has a list of only 4 items (data source Y1:Y4) instead of 30 items:
ONE and TWO with THREE of FOUR and FIVE
FOUR off ELEVEN and ONE before TWENTY
FIVE after ONE
TWO out TWENTY in FOUR

And suppose B1 has the data validation list (data source Z1:Z3):
ONE
TWO
FIVE

4) Selecting ONE from the B1 list in the above example should limit the list in A1 to the top 3 items (each contains ONE).
Similarly, selecting FIVE from the B1 list, should limit the list in A1 to the 1st and 3rd items. And so on.

5) Nested IF for the A1 list would not only be clumsy at best, but also would fail if more than 7 conditions (i.e.; 7 key words) are in the B1 list. (Keep in mind the actual items in A1 list is about 30 in the real application).

Any suggestions ?? Thank you kindly.

Hi,
I am working on a report, which has a drop down list which are unique products. the list chages the which product the information is being displayed for. What i am wanting to do is to write a macro to automate the whole report. The main functionality i am looking for are:
1. Create a sub folder from a specific range
2. Run the report for each item in the list and save them in a new workbook with item name as the worksheet name.
3. each item to have its own worksheet.
4. save the workbook in pdf format.

any help on this would be much appreciated.

thank you

I have a excel file having 3 different sheets.

Sheet 1 : Partmast
Sheet 2 : Submast
Sheet 3 : Entry

In sheet "Partmast" all Part Codes & Names are stored with column heading CODE and NAME

In Sheet "Submast" all Part Code with SubCodes are stored with column heading CODE and SUBCODE.

In sheet "Entry" i am entering the data in column A : Code, Column B : Sub Code.

I am validating the data by using vllokup and storing "T" in column C if the match is found and "F" if the match is not found.

I want to populate a list box / drop down list of all sub codes for the Code stored in the column A. The list should not include the sub codes not pertaining to Code stored in Column A
The list box / drop down box may be created automatically or on press of a button.
For reference i have attached the excel sheet.

Can anyone help.

Thanks in advance

Regards

Suhas

Trying to create a mountain chart using multiple rows of data. The chart will populate via a selection from a drop down menu. Received an error message stating series can not use multiple cells, rows or columns, only single. Any suggestions on an alternative?

hi,

I keep running into this same situation time and time again so this time i thought i would post the question here and see what others come up with.

I have a column of values in an excel sheet. I want to create a unique list of those values to paste into another worksheet. In the past i have used someething like this

   
SourceRange.AdvancedFilter Action:=xlFilterCopy, _
        CopyToRange:=TargetCell, Unique:=True
the problem is that the unique list that is generated includes the header from the original list.

So my question is what is the best way to generate a unique list from a column of data in an excel sheet and i want to put this unique list into another sheet starting at some cell location and have it paste down the column.

Are there any suggestions?

Hi all,

quick one... I'm looking to try and create an 'active' list of names from a singular column of names which does contain duplicates ie:

Smith
Smith
Jones
Walker
Jameson
Walker
etc..
etc..

say this list is in column A. now what I want to do is create a second list from column A into say column B (or on another worksheet which wil be the most likely outcome), but the list should not be a direct copy, just a list of single instances ie:

Smith
Jones
Walker
Jameson
etc..

the list from the original column A may be appended, so I'd like the function to view the range A:A constantly, so the concised listing will also be up to date - we just have quite a few rows which have the same surname on them.

Does anyone know how to do this using standard Excel functions? I'm a bit rusty and looking for help on this. Tried INDEX options and LOOKUP/VLOOKUP and I'm trying to avoid using macros (simply because my boss is a newbie when it comes to coding - I'm ok with it myself LOL) - basically it is a filter to find and check for duplicates, and only 'report back' names once.

all help appreciated - thanks

i WOULD LIKE TO CREATE A SUMMARY LIST OF TOTALS OF ITEMS IN THE SAME STOCK
ITEMS RECORDED ON A NUMBER OF SPREADSHEETS FOR DIFFERENT SUPPLIERS. tHE
SUPPLIERS WOULD BE LISTED DOWN THE LEFT HAND COLUMN AND THE STOCK ITEMS
ACROSS THE TOP.THIS WILL ENABLE ME TO LOOK AT A LIST OF ALL THE STOCK BY
SUPPLIER

THANK YOU

Hi all,

I have created a tracking sheet that will be used to track employees attendance of daily workshops. On a seperate worksheet, I want to create a dynamic filter that will allow me to filter the tracking sheet based on certain criteria of the attendees such as their language or supervisor.
I've managed to do it to a point but run into problems when there are multiple entries on the same date. The employee data has a unique employee ID number attached to them which I can use to distinguish one from the other but I can't figure out a formula to order them in the dynamic filter. I've tried arrays and various formulae such as LARGE, SMALL and RANK to try and sort them somehow that way but my brain has stopped working now and I can't think...
Could someone suggest the best formula to use here?

Thanks

I need your help, I am an average Excel user, using our office provided Excel 2003. I am trying to create a sub-list from a master list based on a column criteria.
Basically, we have a large group of people that are now being split into 3 different sub groups, but still part of the whole. I would like to only upkeep the master list by assigning one of 3 managers to each employee and then having Excel place the employee's info (5 columns) into a seperate worksheet based on the manager assigned (3 seperate worksheets, one for each manager)
I have searched through books and Excel help, but still cannot find any formula that can return multiple lines based on one criteria. Am I out of luck and forced to maintain this database with an Auto Filter and manually moving/copying the info?

Does anyone know how to link the edits made in a sub-list so that they appear in the master list? Here's what I have:

- I have one main list with all my data.
- I have created several sub-lists from this main list (by filtering the main list, and saving the filtered data as a new list)
- I want to edit the data in the sub-list and have those edits also appear in the main list. they would need to be linked somehow.

(I know how to set it up so that when I edit my main list those edits appear in my sublist, but that's not what I want, I want the reverse)

Is their some way to do this? or am I shooting in the dark???

Thank you!!!

Hi, I am a complete excel novice, just wondering if the following was possible in excel or can someone point me to some resource that will be able to help me.

I want to be able to create a shopping list based on different meal plan's selected. So I want to be able to select "chicken pasta" and then the ingredients that are in this meal get added to the shopping list.

Thanks

i have an excel spreadsheet with about 2500 e-mails and would like to see if
i can create a distribution list from excel to outlook. is there a way to do
this?

How do I create a detailed list of files in a directory, with date created,
modified, etc?

HI,
is it possible to create a list of parts from a selection in one drop down box

ie
i have 1200 parts with descriptions etc in list . using a drop down box i want to select and create a workto list.

ideally this list would start on another worksheet starting on row 10

thanks steve

I am trying to create a data input page where I select the relevant information from drop down lists (which I have already set up) hit ENTER and it will automatically create an entry on a list on a separate page
for example:

COMPANY: NAME: DATE: TIME IN: TIME OUT: MAKE ENTRY

List generated automatically on separate page

COMPANY NAME DATE TIME IN TIME OUT
Generic Bob 22/03/2020 8:20 14:30

Hope that makes sense

Thanks

Also see the attachment if it worked

Hello

I'm able to create a simple User form Drop-down list that references a cell range list. ( as a test for myself)

I have 4 separate macros I would like to run individually. Rather than create 4 separate buttons, I'd like to be able to select each one via Drop-Down list.

How can I assign this code?

Do I need to use a User form for this?

Thanks

Jeff

I need to create a cell with possible drop down list without a pre-formed
range of cell

Hi

I am using the following code to enable multi select from drop down
lists in XL2003, but have a group of users requiring this feature in
XL97...

Public InActivity As Boolean

Private Sub Worksheet_Change(ByVal Target As Range)
If InActivity Then Exit Sub
InActivity = True
On Error GoTo NonValidatedCell
If Selection.Validation.Type = xlValidateList Then
ColAbs = Target.Column
If ColAbs 3 Then GoTo NonValidatedCell
RowAbs = Target.Row
If Sheets("Recreation_Activity").Cells(RowAbs, ColAbs).Value = "Delete
Contents" Then
TotalString = ""
Else
Application.Undo
TotalString = Sheets("Recreation_Activity").Cells(RowAbs,
ColAbs).Value & ", "
Application.Undo
TotalString = TotalString &
Sheets("Recreation_Activity").Cells(RowAbs, ColAbs).Value
End If
If Left(TotalString, 1) = "," Then TotalString = Mid(TotalString, 3)
Sheets("Recreation_Activity").Cells(RowAbs, ColAbs).Value =
TotalString
End If
InActivity = False

Exit Sub
NonValidatedCell:
InActivity = False

End Sub

The spreadsheet opens in XL97 without error but you can only select
one item from the list...
Selecting a second item just overwrites the first..

Any suggestions??????

I'm trying to create a drop-down list (in Data Validation) that is populated
by the subset of a larger list. The larger list is not sorted, nor can it
be. If possible, I'd prefer not create a subset list elsewhere in the
worksheet and have a list in Data Validation refer to it. Ideally, I'd like
to enter a formula in the Source: box (after choosing List under Allow: in
Data Validation) that would create a filtered list from the larger list.

It's difficult for me to explain this well, but maybe an example will help:

I have a table of baseball players, 20 rows by 3 columns (columns are
Position, Name and Batting Avg.). I'd like to create a pull-down menu, below
the main menu, with just first basemen in it (and let's assume there are 3
first basemen in the larger list).

Any help is greatly appreciated, I've been struggling with this for a while.

When the (right-click) "Pick From Drop-Down List..." command is used in Excel
to facilitate key-entry, it only works for contiguous entries in cells in the
column above the input cell. blank cells in between break the link.

Is there a way to designate a named range of terms as the basis for the
"drop-down" list?

Microsoft,this should be a standard option!

I have created a list in cells A2 thru A13. A1 has text 'Month & Yr'
entered. When I right-click in A14, I do not have the option of Pick From
Drop-Down List... appear. I have this in another file that was converted
over from Excel 2000 & it works fine. What am I missing in Excel 2003?

Thanx! Mary


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