Dependant List - Organize The Ordering Process From Wholesalers?
Dec 21, 2013
I have a list on flower names in column A , and the colors in Column B. For sorting purposes I have duplicates in Column A. I am creating an easier way for coworkers to organize the ordering process from wholesalers. On the order sheet It will have the dropdown that lets them choose the flower (ultimately I hope to make this searchable,) Once the flower is selected the next column will allow them to choose from the color available. Attached Is the sheet with my work so far.
View 8 Replies
ADVERTISEMENT
Oct 21, 2013
I would like to reorder a list whilst ignoring any 0 values. I've attached (I hope correctly!) a spreadsheet of what I mean. It's pretty simple, but I've been banging my head over it for a while now!
Sample.xlsx
View 4 Replies
View Related
Jun 18, 2014
Is there any way to organize a list of various months and dates
First by creating a column of just the months, then by all of the dates, serperated by commas?
View 1 Replies
View Related
Aug 28, 2007
I have a question regarding the data validation lists. What i have is 4 different lists
Department
Assays
Instrument
Manufacturer
What I want to do is...once a user chooses a department, he gets a list of assays done in the chosen dept. and also a list of instrument used by the dept and a list of manufacturers
I used the examples shown here
http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal02.html
and was able to succeed in creating dependent lists to some extent...I am attaching whatever I have able to accomplish so far, which is able to pull up the assay list based on the dept. ...but am confused as to how to get the Instrument and Manufacturer list at the same time .....please choose 'Chem 2" from the dept list to see what I have managed to do so far
View 11 Replies
View Related
May 4, 2009
I would to say thank you to RoyUK for helping me out with this DependantlistBoxes where a Userform has two columns. Now I've manupilated a Userform so that whenever I double click on the cell, the selected text from the second box in Userform is pasted to the cell in the next column to the right.
But I what I really want it to do is to past the text fromt the first box in Userform to the active cell and when move to the second box in Userform, the selected text will be paste to the cell on the right.
Like I double click on B3 (in "Fullarton") sheet, a userform appear. When I choose CB from the first box in userform, it should paste in B3. Then when I choose Electrician from second box in userform, Electrician should be paste in C3.
View 2 Replies
View Related
Sep 28, 2007
I have on a sheet:
4 data validation lists that contain the exact same values.
would like to have:
One validation list box that is dependant on all 4 vd lists.
I posted a thread on dv and came to the conclusion that it is not possible to use INDIRECT() as it only allows for one cell reference and not four.
Is there another way to do this?
Glove Man, I tried your suggestion but couldn't get it work.
View 9 Replies
View Related
Jun 10, 2009
Im trying to create a 'drill-down' interface with the GETPIVOTDATA command.
I believe (but im not sure) that this will require several different formulas.
e.g., assuming this formula resides in A1, this returns all data in the pivot $A$6 for Monday of 6/1/2009:
=GETPIVOTDATA("Sum of Mon",$A$6,"Week", DATE(2009,6,1))
however for cell A1, if the user wants to drill down, then the required formula expands to the following..in this case we are drilling down to Name=Baby Becket/Ball, Stage=Infant..and so on..
=GETPIVOTDATA("Sum of Mon",$A$6,"Name","Baby Becket/Ball","Week",DATE(2009,6,1),"Stage","Infant","B/L","B","WL",)
Essentially, without writing a bunch of IF's in the formula for A1...is there a way to put these formulas in a lookup table, and then depending on what the user chooses on how they want to analyze the data (e.g., they may select Name, Stage, etc from a drop down list elsewhere on the sheet), the appropriate formula is populate in A1?
In a nutshell: Can the formula of a cell be changed depending on what the selection value is of another cell or list value?
This could probably been done easily via VBA, but if there is a formula or vlookup based solution that would be easier..
View 9 Replies
View Related
Dec 9, 2009
I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.
If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.
View 12 Replies
View Related
Jun 1, 2009
I have about 45 worksheets in one file. Then all have been named. Is there any quick way to order them? I would prefer not to move each one.
View 2 Replies
View Related
Jul 12, 2009
what i want to do is have a formula set up that works out who has the best position and then re order the number rows to put the player in position 1 at the top. so just moving cells c-n
View 6 Replies
View Related
Sep 4, 2009
I need to ensure that a worksheet is ordered after another in a workbook. The macro that this code is in opens a selected file and carries out various operatins on it, so although I can do this fine when the worksheet needs to be created, there are scenarios where it already exists and I simply need to change the order. The sheet that must come in position 1 does not have a common name and so I cannot reference it via it's name in the code. The other sheet is named when it is created so it doesn't necesarilly have to be in position 2, it's just that the other one needs to be in position 1.
View 7 Replies
View Related
Jan 29, 2010
A number of columns (B to U) contain names, details and scores of players. The A column contains the ranking, e.g. 1 to 100.
If a player (row) is deleted, that ranking number is also gone. Is there a way to make the A column always maintain the integrity and completeness of the numbering, e.g. if rank (row) 16 is deleted, the range of B17:U100 moves one row up and the former 17 is now 16? And if a new row is inserted, the ranking numbers after the insertion move up one row and a new number is added at the end?
2. There are 6 columns of scores, P to U. But out of these 6 scores, only the best 4 count for the ranking. The two worst (highest) scores are dropped. Is there a way to automate the process by selecting only the 4 best (lowest) numbers to be summed into the Total column (C), which in turn determines the rankings in the A column?*
And then can the whole range B2:U100 automatically be sorted according to the ranking in column (A)?
*It is possible that there are 3 or 4 bad scores, all with the same value. In that case only 2 could be discarded, and 1 or 2 would be summed into the ranking cell.
View 8 Replies
View Related
Mar 9, 2008
How do you do a lookup without having to have a list in ascending order?
View 9 Replies
View Related
May 1, 2008
i have a 5 by 10 table (5 columns 10 rows)
values only equal 1 or blank
i want to re-order this table in another identical table so that no row will have more than one value (each row will have a maximum of one "1")
currently, the table looks something like this:
blank blank blank 1 1
blank blank blank blank 1
blank blank blank blank 1
blank blank blank blank blank
blank blank blank blank blank
what i would like the idential table to show is:
blank blank blank 1 blank
blank blank blank blank 1
blank blank blank blank 1
blank blank blank blank 1
blank blank blank blank blank
View 9 Replies
View Related
May 30, 2013
I have 320 rows of data, of which the date is in the first column. I need the data sorted into date order, ie. 04.05.12-->30.04.13 and all the dates in-between (note these are British laid out dates). I am aware, and have already done Format Cells --> Date --> 14.03.01, as this is how my dates are laid out.
I've tried sorting this column, ascending, descending etc etc etc, obviously it needs to be 'expanded' to ensure that the rest of the data in the row follows it to its new position. No joy. It only ever sorts the dates by the day ie. 02.04.13, 04.12.12, 06.06.12. Doing it by the day and not the month and the year also.
I don't want to order 320 data rows myself!
View 3 Replies
View Related
Jun 6, 2009
I have an enquiry where I'm trying to order error messages which occurs in if, ElseIf and Else Statements. The code I have works. However, I would like the error messages to be checked in a particular order. I tried rearranging the conditional statements but had no success. Here is my
View 5 Replies
View Related
Sep 28, 2008
I want to have them in order of shortest price (favourite) first with the relevant horse's name in the adjacent column. I have just discovered vlookup which seemed perfect - until I discovered that when there are two or more identical prices it only returns the 1st horses name.
Is there any way I can use vlookup to do this (with more than one identical value)
View 9 Replies
View Related
May 20, 2006
im having trouble trying to figure out how to organize the following data. It concernc cycling races that has its own data like type of race, country, number of mountain stages etc. but also for each race i need a subcatagorie wich holds the data of all riders that participate in it. like;
Race: Categorie race: Number of mountain stages: etc.....:
Tour de france Grand tour 8 ...
Giro d.italie Grand tour 19 ...
but also for each race:
Race: Teams (wich will need up To twenty names): Riders (For Each team up To 9 riders:
Tour de France Gerolsteiner Totschnig, Zberg, etc...
Tour de France Discovery Channel Armstrong, Beltran, etc...
How would you organize information like that, the trouble is it must be able to use all the excel functions AND be able to update the list trough an webquery and VBA code.
View 3 Replies
View Related
Jan 26, 2007
I am trying to come up with a formula which would combine two groups of numbers, put them in numberial order and remove duplicate numbers:
3 6 10 22
1 3 5 9 10 13 19
The above two groups of numbers are in separate cells in two different rows.
the result would also be in a different row: 1 3 5 6 9 10 13 19 22
View 14 Replies
View Related
Jun 7, 2013
I need to make a spreadsheet on excel which shows the production schedule of a product over 4 days.
Then I need to make a supply ordering sheet which shows how much supplies are needed to do the above task and how much each item in the supply list will cost and when the items would need to be ordered.
View 4 Replies
View Related
May 30, 2012
I have a bunch of worksheets with various data that is in columns ranging from 1 upto 20 (this is different with each sheet) across and each column has data rows that has various numbers.
What I want to do is create a sheet when I need to organize some data and control A all the data and paste on to this sheet hit a macro and have it take all columns and stack them in to column A.
Each row will have a different number of populated cells and there are sometimes 5 columns up to 20 columns
Example
Column A - 100 data pieces
Column B - 325
Column C - 100
and so on...
The macro should leave all items in column A but then cut all 325 records (row 1-325) and then paste them starting in cell "A101" then move to Column C and stack those below what was moved form column B and so on.
The code will stop at the first blank space in each row and will go from right to left until it hits the first blank cell in the columns.
View 3 Replies
View Related
Jul 15, 2013
setting up a stock ordering system in Excel. I have been sent a spreadsheet with about 400 items I've ordered before and about 15 columns of descriptions which include the name, category of item, manufacturer, cost, number etc.
I would like to set up a simple Excel spreadsheet which staff can use when they want to order some stock, which will automatically fill in the adjacent cells with the product category and unit cost, once the name has been typed into the first cell. Once I add the SUM formula I can therefore have an immediate total of how much each staff member is spending on stock that week, without having to look at the invoice I get back from the supplier.
I know Excel has a predictive text style feature (autocomplete?) but I don't know how to get it to automatically fill several cells in a row with data that is linked to the first cell.
View 14 Replies
View Related
Feb 9, 2007
I have the following macro:-
ActiveSheet.Select
ActiveSheet.Copy
Columns("A:D").EntireColumn.AutoFit
Range("A2:B500").Select
Selection.Sort Key1:=Range("B2:B500"), order1:=xlAscending, Key2:=Range("A6:A250"), order2:=xlAscending
Within this I would like to add a couple of features which check:-
1) If there is a number in column A - there should be one in column B
2) The numbers in column B are sequential i.e. 1, 2, 3 etc without any gaps in the sequence
View 9 Replies
View Related
Feb 14, 2010
1 - We receive an excel file from our customer (approx 20 different customers in total)
2 - I have an excel template we have to use, which will import into our MIS software. This excel template must remain the same or it wont import into our system. ie (Columns must be in this particular order)
3 - Our customer sends their own spreadsheets in their own formats ie, column in a different order to our excel template.
4 - I need to know if there is a quick way to remap customer columns into my excel template
5 - Im looking for a little application that will look at the customer spreadsheet and our template in the same window and let me link which fields need to map where in my template. When I have completed I can save what ive done and run when needed for this customer.
View 9 Replies
View Related
Jan 7, 2014
First, I tried to input Ibs, Size, Items into a worksheet with layout.
Then, calculate how many items are they and separate them into two categories - "Big" and "Small".
Final, I would like to create another worksheet to evaluate how many items belongs to "Big" and "Small" with a column chart to present.
Question : How can I accrue the total of items and sort them into the right categories automatically.
View 3 Replies
View Related
Mar 16, 2014
I have list of county roads and would like to organize them by odd number and pair. Macro that can change the pair number first then the odd number here is an example
ORIGINAL LIST
COUNTY ROAD 32 & COUNTY ROAD 55
COUNTY ROAD 36 & COUNTY ROAD 55
COUNTY ROAD 51 & COUNTY ROAD 48
COUNTY ROAD 48 & COUNTY ROAD 35
[Code] ...........
View 4 Replies
View Related
Mar 4, 2009
I have been trying to do this for 3 days using "Record Macro", but something always seems to be messed up. The main problem is that the worksheets are protected and the macro asks for the password.
Here is a calendar sheet that I've been working on. It contains the calendar on sheet 1(not important) and a client roster on sheet 2. The client roster gets filled quickly, and obviously gets unorganized. What I'd like to do is create a macro so that when a date is entered into column AA (when a client is discharged), that entire row is moved onto sheet 3 (Discharged). At the same time, I'd like all of the names in column A alphabetized.
I even tried to create an "Organize" button so that the users could just click it and alphabetize. The problem I ran into with that was that the users are using Office 2000, and the names get alphabetized but all of their information no longer matches up.
View 3 Replies
View Related
Mar 31, 2009
I have a column of numbers and I want to copy numbers, with a constant periodicity, and paste in a new column. In the example below, I copy values from column A and past in column B, picking only every third value:
A B
1 1
2 4
3 7
4 10
5
6
7
8
9
10
View 7 Replies
View Related
Nov 6, 2008
My sheet has a bunch of Name's in column D, either the text "Store" or nothing in column E, and a dollar value in column F. I'm trying to figure a way to display the names in order of highest to lowest dollar value based on the criteria that the name must have the text "Store" next to it in column E. If column E is blank then the name would not be included in the ranking. I thought I could use the following code to accomplish this:
View 13 Replies
View Related
Nov 17, 2013
I did a survey of what kind of clothes people like to wear and why. So there are two things that people have to write down. ex) jeans and cus they're comfortable / shirts and cus they look good
The data that I received was organized as followed
I just put in random things just so you can get the idea of whats what
Id
jeans
shirts
cardigans
[Code].....
Okay so what I want to know is how I can get the responses from the data spreadsheet I showed you before into this organized data table above.
View 3 Replies
View Related
