In column A, I have the following items (chair, table, bed, sofa, wardrobe, shelves, etc) and these itmes apprear more then once. I have named the range as "product".
I want to use the same range to create a list under data menu (Data / Validation / Allow = "List" / Source = "Product") , apparently since the items appear more than once in the range the same gets populated in the list.
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
[URL]....
[URL]....
I am aware there are people with more pressing problems than computer games and as such
I have a worksheet in which Col. A contains the names of London boroughs and col. B contains the name of each Ward in that borough. I'd like to create a list (or combo) box showing all the London boroughs, and a second list (or combo) box which will show all the Wards for the Borough selected in the London list (combo) box. I'd also like the option to be able to select all the Wards for the borough selected so that they can be used in a chartgraph.
View 2 Replies View Relatedi have a list in a database which is populated by a textbox on a userform. the list is money. i want to keep a running total which is then recorded in a textbox on a user form. when i have tried to do this the total does not drop down so i cannot populate the list.is there some code i can use to do this or do i have to drag the total further down the column.
View 3 Replies View RelatedI have an Excel sheet and I want to populate a list in sheet 2 from data that I will include, little by little, in sheet 1 (I send this information by e-mail, using Excel). With this i want to create like a log to keep a record of what I send every time.
Sheet 1
Document 1
Studio xx
Word count500
Language Spanish
And I just want to have in sheet 2 the following information
Document Wordcount
1 500
I don't need more but I would like to add a new document every time and be able to have a log in which I know the word count that corresponds to every document so that with time I can have as follows in sheet 2:
Document Wordcount
1 500
2 750
3 200
I have been trying to add a button to do this, but it didn't work the 10 times that I tried.
im trying to create a spreadsheet for different makes of cars, here is what i want to do.
in cell one i want a drop down list for various makes of cars, in cell 2 i want another drop down list for the different models from that manufacturer (depending on which on I choose in cell one), in cells 3 and 4 I want different information depending on the make an model of the car. I have got 1 sheel with all this info on it but I dont know how to make it all work nice and neatly with drop down lists.
I have been using this formula in my report for a while now and i have just updated the table at which it looks at. The table consists of 3 columns - store, store number & division. The value at what vlookup looks for is the store and i have sorted this alphabetically.
But now when i choose the store from a drop down list i get nothing populated in the cell with the formula!!!
=IF(ISERROR(VLOOKUP(I5,$Z2:$AB$419,3)),"",(VLOOKUP(I5,$Z2:$AB$419,3)))
I am struggling to populate a listbox with data from a different worksheet.
If it is the current worksheet works fine.
The worksheet is called "Drawing Data" ..
I have a workbook with about 25 different sheets and each sheet has the same in cell listboxes on them and If I get another item I need to add to them I have to go to each sheet and update them, is there a way to make one list to populate each list from?
View 5 Replies View RelatedI have form with a list box lstEmpName which is populated from a sheet "Records" range a1:a35. This is in the UserForm initilize sub.
When a name is selcted I want the corresponding payroll number (found in Records range B1:b35) to auto popuate the txtPayroll box. I've had a go at some code but it's not working in the Userform Initialise sub and I don't even know if this code would work.
txtPayroll = Sheets("Records_LookUpList").Range("B" & lstEmpName.ListIndex + 1)
I have three sheets. A raw data sheet, a sheet of formatted data, and a third sheet with a list of invoice numbers.
I've already developed the code to format the raw data to the formatted data sheet. What I need is to populate the third sheet with the invoice numbers I've used, and not use the data from the data sheet if the invoice numbers are on the sheet with the list of invoice numbers.
I need to do this via a macro.
Is it possible to populate a multicolumn listbox while excluding the hidden rows?
View 3 Replies View RelatedI have a list of data with 2 column. One is a column of unique values, the other column has a lot of blanks.
I'd like to auto generate both columns without any of the blank data from column 2. I've attached a mock spreadsheet of what I'm invisioning.
I have a drop down list with 6 recipes. When I select chocolate for example I want that to automatically populate different cells in the worksheet based on a standard I have created for that recipe. The recipes won't change they just have different ingredients and I want that to show up depending on what I select on the drop down list. I went into VBA and worked a little with this starting code:
If Target.Address = "$F$3" Then
Target.Offset(0, 1).Value = "1"
but It wouldn't populate separately based on what I had selected in the drop down it would just populate all 6 recipes the same.
The list is over 1500 records for each
I was wondering if there is a way I can fill in the region and country columns automatically -i.e. through a script or function or macro based on what is entered in the town row/ field
e.g
Town= Cheltenham
if the town is Cheltenham, I would like the corresponding region column to pollute with glouctershire
I have tried using functions such as:
=IF(A3="CHELTENHAM","Glouctershire",IF(A3="LONDON","LONDON",IF(A3="Leeds","Yorkshire",A9)))
but as I have over 1500 towns, the error message comes up in excel stating the formula is too long- I think it is limited to 255 characters or so
Is it possible to use a drop down list to populate cell elsewhere on the same worksheet?
View 9 Replies View RelatedSome Background info:
This is my first post! I am a total novice when it comes to VBA in Excel (but I'm a fast learner!), so please bear with me if my question is either obvious or easy (or if this is a question that's been asked 14980213 times already). I have some programming experience, but all in C or C++, not in VBA--this makes the project challenging. I also have to hand this off in a few months and trust that it'll never break, ever--more challenging.
I'm trying to make a Participant Tracking System for some workshops we offer. The intent is to make a userform so that an administrator can input all the information for the participant in question. One important question on the form is which course the participant intends to take; the snag is that the current list may change over time.
The Spreadsheet is set up with Course headings starting at R8C8, and continuing across for all 16 courses we currently offer. The data for the participant is entered into Rows 1-7, and the date they completed the course in the appropriate column for that course. There are some formulas in Rows 1-7, the important one here counts up the number of classes currently offered.
So, below is the code i'm trying to use, at least to start. I am making a combobox that has all of the available classes.
Private Sub UserForm_Initialize()
Dim ClassList() As String
'R5C6 contains a formula that calculates the number of classes offered. The value is currently 16
Redim ClassList(R5C6)
iCount = 0
y = 8
Do While iCount > R5C6
'R8C8 is where the class list begins.
'It continues horizontally along the rows for the 16 titles offered.
Range(R8Cy).Select
ClassList(iCount) = ActiveCell
y = y + 1
iCount = iCount + 1
Loop
With ClassListBox
.Clear
.List = ClassList
.ListIndex = -1
End With
End Sub
I used to have a line that replaced the following chunk.
Range(R8Cy).Select
ClassList(iCount) = ActiveCell
It read
ClassList(iCount) = R8Cy
and did nothing for me at all.
When I initialize the userform, I get a blank combobox. It doesn't do what I want it to do, but that's probably because I'm telling it to do something weird.
I used this forum to find code to convert a matrix to a list. But I need to repeat then change one column - "Product".
The "Prodcut" vlaue needs to repeat unitl it changes.
I have attached a file with the code in module 1, and samples of where I am, and where I need to be. I think I am close!
I'm trying to make a listbox that contains a list of items from ranges that differ depending on the contents of one cell.
In other words, say the contents of the cell in question is 'flower' the listbox will be populated with the range of cells containing flower names; if the cell was 'shrubs' the same listbox would be populated with the range of cells containing shrub names.
I've scoured the site, but can't find an exact query that matches mine (though I've probably missed a bunch of them).
When I enter a value for 'Number of Steps' from a drop down a table is generated with the x values changing accordingly.
For example:
Number of Steps 5
x x^2
------------
0 0
1 1
2 4
3 9
4 16
Number of Steps 9
x x^2
------------
0 0
0.5 0.25
1 1
1.5 2.25
2 4
2.5 6.25
3 9
3.5 12.25
4 16
You will notice that the number of steps is the number of x values that take us up to 4. The 4 is fixed. I would be able to work out the maths myself as I am a maths teacher but I was wondering how I could autopopulate the table based on a drop down box selection. If it involves going into VBA then don't worry my son needs to get to grips with what I have done.
Edit. The formatting does not seem to work above. On the left of each table is supposed to be the x value and on the right is x^2.
I have 2 columns in FINAL list: A product number and a price. The product number is full, the price one isn't and it's the one I want to fill. I have several other TEST lists with the same two columns, and both are full. I need to have excel check to see if a value in the product number column matches one in the FINAL list, and, if so, to copy the corresponding price value from the TEST list to the proper corresponding place in the FINAL list.
View 3 Replies View RelatedI have a worksheet which contains all the details of the medical equipment in the county that i'm responsible for.
This worksheet posesses amongst others; two columns titled location and sublocation.
I need a technique which will allow me to select a location from a dropdown list, select a sublocation again from a list and for these two conditions to then populate a list containing data such as asset code and description of all the items in the location and sublocation (possibly a little like an advanced filter, but only for the selected conditions)
This list will then be used to provide an engineers report on equipment holdings at various locations. I'm open to any ideas fellas.
I have been sent a price list from a supplier and need to create an order form that can be populated from the price lists. I have to pages of price list as well. I will also be adding to these as I start getting other supplied product and need my client to be able to generate a order from these in the simplest way possible. Again I hardly use excel and these docs are all sent in excel format.
View 4 Replies View RelatedI am wanting to randomly select one of two cells and then populate that cell from a list I have on a different sheet.
View 1 Replies View RelatedI have systems that spit out text log files showing machine performance. Each log file has about 5000 lines of data in it which I import into excel for processing. One of the columns has a machine voltage that changes with the machine state. There might be 10-15 discrete values (like 500V, 800V, or 1000V) within the 5000 lines. I'm trying to populate a list box with just the discrete values so the user can choose what state to process for charting. Some log files might only have 2 or 3 voltages others might have 15 or more so it isnt fixed. I've been trying to use an advanced filter with copy to location and unique records selected but I run into problems with the variable size of the list and with the fact that the header repeats periodically and I can't seem to screen that out of the list.
View 9 Replies View RelatedI have two tables on two different worksheets. I would like to automatically populate a distinct list into column A in table 2 from the data in column A in table 1.
Table 2 must auto populate from table 2 every time a new row is added into table 1 - without any extra user interaction e.g. pressing a button etc. No offense intended to my better half but if she has to do anything more than enter a new row in table 1 she'll likely manage to screw it up after a week
I kind of managed to get it working using the below formula but both sets of data must be in tables so I can't copy the formula down the column without creating redundant table rows.
=INDEX(Classes!$A$2:$A$999, MATCH(0, COUNTIF($A$1:A1, Classes!$A$2:$A$9), 0))
Example
Sheet 1 = "Classes"
Column A = "Student Names"
John
Mike
Paul
Andrew
Paul
Paul
Mike
Sheet 2 = "Total Due"
Column A = "Student Names"
Paul
Mike
I am looking to auto generate a roster/schedule. I have a spreadsheet with shifts for each weekday that I need to populate every week with names to pick from a drop down list. the drop down list is made using data validation and looks at a dynamic named range to allow me to select only the people who are available to work a certain shift.
Is there a way to do this using vba?
I have sheet 1 a1:a3 with 3 check boxes.
In sheet 2 i have 3 ranges green = a1:a20, red = b1:b20, orange = c1:c20. (in each range there is a different list of customers) What i would like is on sheet 1 to click check box 1 and the values from range green (on sheet2) are dispalyed in sheet 1 @ d1
Populate Adv Filter Criteria from Inputbox with valid data
I've set up a macro to extract 3 different sets of data using Advanced Filter (same data range, different criteria & extract ranges)
There are multiple options (different individual dates) to satisfy the criteria (a date) for each of the 3 extracts and I want the user to select the criteria (a specific date) from the range of unique values in the data range upon which the Advanced Filter criteria is going to be applied. (A bit like the effect provided by Autofilter)
My initial attempt was to capture the criteria date from the user and populate a cell, and then have a vlookup function in another cell check if that crieteria value exists in the specified range. I then ran a loop in the VBA code until the value is valid (ie. exists in the range). However, to streamline this I was hoping to allow the user to see a list of the valid (available) dates when they respond to my Inputbox request for the criteria.
I have a # of months in P11, and a Start Date in P12:
P119 Months126/1/2024
I need to excel to autopopulate monthly dates from the Start Date = to the # of months displayed in P11: ...