Variable Dropdown List For Inventory List

May 24, 2014

Im trying to organize a tools inventory list. Its supposed to be sort of like an order sheet for each department. But what I want to do is when I select either CARPENTRY, or any of the other trades from a drop-down list, I'll be able to select from another drop-down list items associated with that trade in particular. So eventually I want the master data hidden, preferably in another sheet. I searched all of Google but it seems a bit complicated to get it done. I've attached the sheet so that you can see what I'm talking about. MOVE IN MASTER LIST.xlsx

View 8 Replies


Creating Spot Check List From Inventory List

Mar 17, 2014

I am looking for a Macro that would randomly select 20 items from my inventory list for performing spot checks. Column F of Active Coil Log tab is where the data would need to pull from, however I would like all data in the row to go along with it. I've explored the RAND functions, but they don't seem to be the right fit .

View 2 Replies View Related

Eliminating Sold Inventory From The Inventory List

Aug 8, 2006

I am not an excel whiz, so I will need layman's terms if possible. I may have found a solution to my problem under another thread, but I couldn't understand it. I have only briefly worked with macros, a very long time ago. Here goes...

I have an inventory list that has not been updated for sales of the inventory, only for purchases. I have sales lists, generally by month, in separate spreadsheets. I am looking for a simple, efficient way of either eliminating or at least matching up the data in the sales list to the inventory list in order to remove sold items from inventory (on paper). I am hoping the result will be a fairly accurate inventory list, and related value, so that a physical inventory count won't be necessary at this time. Obviously I could copy all of the sales info into one spreadsheet, sort by inventory number, then manually delete all sold items from the inventory listing. I am REALLY hoping there is a better option.

View 6 Replies View Related

Excel 2010 :: Keystroke To Select Variable Name From Dropdown List?

Jan 23, 2013

I've defined a number of variables in my spreadsheet. When I want to use one I type "=variablename" and 'm presented with a list menu.jpg

In the above example, I have several variables starting with the word "Harvard" (a town, not the university :-)

How do I select one of these without having to double click with the mouse.

Up and down arrows allow me to highlight an item but I cannot find a keystroke that allows me to select the highlighted item. Instead I have to lift my hand off the keyboard and use the mouse.

Excel 2010

View 2 Replies View Related

Creating A Dropdown List Using Matching Data From 2 Columns To Populate The List

Jun 11, 2013

I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.

My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad



I am aware there are people with more pressing problems than computer games and as such

View 7 Replies View Related

Dropdown List From Comma Delimited List In Single Cell

May 9, 2014

Is there a way to create a drop down list from a comma delimited list in a single cell? For example, col A is Name & Col B is the delimited list - Blue,Red,Green (list can be different for each name). Would like a drop down list in col C that allows you to pick one of the values from Col B.

View 3 Replies View Related

Getting Conditional Formatted Dropdown List Items To Keep Their Formatting In List

Feb 12, 2014

I found code online that I can put on my sheet to get my formatting properties to stay the same for the items in my dropdown list located on another page. However the code does not work for conditional formatted cells...which is what I need. This is the code that I have that will carry over regular formatted cells. Just not Conditional formatted cells.

View 1 Replies View Related

How To Get Unique List From A Column To Data Validation Dropdown List

Oct 28, 2011

I'm looking for a way to get a unique list from a column to a data validation drop down list. Any fancy formula or vba script to create a UDF which. Does this?

View 5 Replies View Related

How To Create A List Of Items For Use In A Dropdown List With Data From A Different

Mar 17, 2007

I Attached a sheet for what i'm asking about ,, i sent it before but the sheet showing it more clearly

View 10 Replies View Related

List Values From Multiple Columns In A Dropdown List

Dec 17, 2012

how to list values from multiple columns in a dropdown list based on lookup value of 1st column as below.

This is how the table looks like.

4" AB1 AB2 AB3
6" ZA2 zd4 -

This is how the dropdown list should look like for Product 4"


View 6 Replies View Related

Dropdown List Based On List In Another Cell Using Indirect?

Jan 29, 2013

I have 3 related dropdown lists that work perfectly, if you enter data from left to right. But, if you click in the cell containing the second list, which is based on the first list, of which nothing has been selected, you can just type any value in the cell. Is there a way to prevent this, or at least validate that what is entered is a value in the list.

View 5 Replies View Related

How To Find Text In Dropdown List (if More Than 400 List)

Sep 28, 2013

Easy way to find the drop down list , if more than 500 list. at least the very first letter of the text.

View 1 Replies View Related

Attempting To Create Inventory List....

Mar 4, 2008

(Excel 2007)

What I'm trying to create is a way to populate a quick inventory list with my bar-code scanner.

I've already learned that in order to have excel move to the next row each time a 12-digit SKU number is scanned, I'm going to have to utilize a userform text box.

My problem:

I don't even know how to begin coding the text box to accept a 12digit number, enter it into the next available blank cell (I'd like it to populate vertically) and then ready itself to accept the next available 12digit number.

My desired end-result:

My scanner is attached to a lengthy USB-Extension, so I can roam my store and quickly scan the inventory on display. For that reason, running back to my laptop and striking "Enter" each time makes the whole solution pretty useless.

Once finished, I'm assuming I could use excels count feature to tell me the quantity of the items I have on hand.

View 9 Replies View Related

How To Make Inventory List Using Barcode Scanner

Jan 20, 2012

i am brand new to this forum, and not so fluent in excel for more complicated tasks.

i have been looking for a solution for this online, but seem to be running in circles, so thought i would post here.

I want to make an shipping list using a barcode scanner. i have a master list that contains all of the inventory numbers and the relevant item data in each row. i would like to be able to scan the barcode of the item and have excel automatically look up the row from the master list and put it into the shipping list.

View 5 Replies View Related

Parsing List Of Inventory Items Into Names And Numbers

Mar 28, 2014

I've got a long list of inventory items. The naming convention of these items is not totally consistent. Below is a representative sample of all the different kinds of names:

1800Brandacom (CLIENTA) 25.00
1800Brandacom 25.00
brandb (Variable)
brandd variable

[Code] .....

I need to separate out the name of the brand and the number (or if the item says "variable", use a 1 for the number) into two columns, so that the results would be:


[Code] ....



[Code] ....

For the numbers, I have used this array formula to search for the first letter in the string, and then search for the first number following the first letter, and then return all numbers up to "." Unfortunately this does not work consistently when there is a number in the middle of the brand name or the item has no number.

[Code] ....

For the names I have used this formula, which fails when the name has a "-" in it.

[Code] .....

Any way to extract the names and numbers which would work consistently across all the items!

View 4 Replies View Related

Cell Value Is Dropdown List Based On Other Cell Value Which Is Also Dropdown List?

Aug 4, 2013

fill the column "Level 2 Area" based on the value selected from "Level 1 Area" which is coming from a drop down list. So the "Level 2 Area" will be a drop down list also based on the selected value from the drop down list from "Level 1 Area".

Level 1 Area
Level 2 Area

View 7 Replies View Related

How To Use Dropdown List

Apr 26, 2012

I have dropdown list witch is "date" in cell A1 in cell C1 i put number witch is "money"

d1:d100 i have "dates"
e1:e100 should get the data from c1

So I use in e1:e100
etc ...

I can use it only for 1 date. I want to choose date from my dropdown list put money and then choose another date and put money.

View 7 Replies View Related

Add To A List With Dropdown

Aug 25, 2009

I was wondering if there is a way to add to a list by a drop down selection.
If there isn't is there a way to do this task easier than copying and pasting?

Here is an example - I'm trying to add the name Benson to the AZ Name list.
Here is an illustration with the drop down but if I can't do this then is there any way that's easier than copying/pasting?

View 9 Replies View Related

Dropdown List Selection

Jan 30, 2007

I am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.

View 7 Replies View Related

Dropdown List That Selects Corresponding Value Instead?

Jul 3, 2014

i am trying to set up a data validation list for the user to select the options from the 'reason' column' but the input in the box would be the 'code' corresponding to the reason

i.e drop down list would show me the' reasons' but when selected it would input the 'Code' only

View 14 Replies View Related

Dropdown List Options

Feb 10, 2009

I have created a drop down list, but when selected the text is really small. I know this is because I am zoomed out, but if there any way for the text to be larger so that I can zoom out and still read what the options for the dropdown list are?

View 4 Replies View Related

Password For Dropdown List?

Sep 2, 2010

I'm required by my manager to produce password protected dropdown list (I use the data validation feature) for purchase order requester. I have been working on it for 2 days now, I somehow got it but it doesnt seem foolproof; as i often get error message after running it a few times.

Basically, all I need is to come up with a unique password for each name for listed in the "Requester". Whenever I click on it, it will prompt me to enter password.Different names requires different password, otherwise it will return as a blank cell.

What are the steps how to edit data validation if possible.

Attached is the requester list : Requester List.xlsx‎

View 7 Replies View Related

Same Dropdown List On Several Sheet?

Apr 24, 2012

I want to have same drop down list on several sheets

For example i have 2 sheets (erik,david)

I create dropdown list in cell a1 (erik)

I want to have same 1 on david sheet

when i change the dropdown list in erik it should be changed also in david and The opposite

View 11 Replies View Related

How To Expand Dropdown List

Feb 20, 2013

I have a data validation list that has approx 40 items.When I select the cell with the drop down list - only 10 or so items appear . I then have to use the scroll bar on the side to look further in the list. Is there a way that more than 10 or so ( possibly all ) items appear in the drop down box when the cell is selected - or is there a way that one can scroll down using the mouse wheel. ( I have to use the scroll bar at the moment ).

View 2 Replies View Related

Link Two Dropdown List With Each Other

May 17, 2013

I have one drop down list in cell A1 and another in cell C1 with the same data. When I select something in A1 I want it to change in C1 also and the other way around. Is this actually possible?

View 2 Replies View Related

Dropdown List With Dates

Aug 18, 2013

If u create a drop down list with dates for eg;August 1st to Aug 31st , is it possible to save or link the date which i want to save some data in same excel sheet.

My idea is if i select august 1st in drop down list , the data which i saved in that date should display , same for the rest of all.

View 3 Replies View Related

Dropdown List Of Hyperlinks

Oct 16, 2013

I have a large amount of sheets in a workbook (, say 70). For example:

1 GrandMastersheet of pets

.....1 Mastersheet of dogs
.................1 sheet of little dogs
.................1 sheet of big dogs
.................1 sheet of blue dogs
......1 Mastersheet of cats
.................1 sheet of black cats
.................1 sheet of white cats
.....1 Mastersheet of snakes ()
.................1 sheet of cobra's
etc. etc. etc.

The names of the sheets in the lowest level are quite long. Creating a icon with a macro/hyperlink in it is not what I want. (Boxes are too big and there would be too many boxes.)

This is what I would like: A clickable dropdownlist in the Mastersheets, that only show the lower level sheets of that category. For example:

A dropdownlist on the dogs Mastersheet that only show the words 'little dogs', 'big dogs' and 'blue dogs'. These words should be clickable and insta-hyperlinked to the specific sheet.

View 9 Replies View Related

How To Emphasize Dropdown List

Feb 18, 2014

I was just wondering if it would be possible to emphasize a drop down list. Basically, because you can only see if there is a drop down list when you hover over the cell, it want to be able to see that there is a drop down list on the cell even when not hovering over it?

View 6 Replies View Related

How To Assign Value To Each Name In Dropdown List

Mar 25, 2014

I have recently found out how to create a dropdown list (easy). Now I am wondering if it is possible to create a dropdown list that has a value assigned to each name in the list?

For example: I have the following list;

Australian states:
1) QLD
2) ACT
3) WA
4) NT
5) NSW
6) TAS
7) VIC

When a person chooses their "state" I want there to be a corresponding value attached to it. These values are:

1) QLD - 0.82
2) ACT - 0.87
3) WA - 0.78
4) NT - 0.69
5) NSW - 0.87
6) TAS - 0.20
7) VIC - 1.17

Is this possible?

View 4 Replies View Related

Tab Links In Dropdown List Via VB

Feb 3, 2014

So I got a list of months in a drop down box that when selected goes to the appropriate month tab that works great. But what I want to do is hide those month tabs that are in the drop down list. I'll add another drop down list with the other tabs to reference back to all the other month tabs so the user can move around. Only problem is when I do hide them they are unavailable meaning when selected it doesn't go the the appropriate tab that's hidden. I want to hide them from the user and still be able to go to them, I'm not worried about the user breaking the sheet. See attached example.

There is VB code in the "Home" sheet. Tab Links.xlsm

View 2 Replies View Related

Copyrights 2005-15, All rights reserved