There's a table with all the raw data in it
camp name
session name
to put in the correct format I am thinking of usinf drop down boxes so that the user can selct the camp name from drop down and based on that the session name can be populated and alos the rest of infomration of that accput in to the specified fields
I am trying to create a sheet for identifying work hazards based on the job assigned. So what I have set up is a drop down list to select the job type. Once this job type is selected I want the pre written hazards to autopopulate in the hazard box. I would also like the required PPE to appear in the PPE box for the job selected.
I have 6 different choices in the drop down list. For each choice I have the hazards and PPE in a separate sheets in the worksheet.
Is there a way to get this information to autopopulate?
I have a problem involving two combo boxes in a user form.
I need to populate different “lists” to combo 2, based on a selection in combo 1.
I browsed through the forum but could not find any solution that made sense to me.
Here are the specifics:
Combo 1 (called Cbo_Act) is populated with a list based on a named range in one of the sheets. The range is named “activity” and holds 2 records (“Income” & “Expense”).
This list is loaded as part of the form initialization.
If the user select “Income”, I need combo 2 (called Cbo_Act_Type) to show a list of various income types (derived from a dynamic named range called “Income_type”) and if the user selects “Expense”, I need the same combo box (Cbo_Act_Type) to show a different list, specifically – a list of various expense types (derived from a dynamic named range called “Expense_type”).
I know that this should be with a Cbo_Act_Change () routine, but for the life of me, I can’t figure out how to do it.
If a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.
View 1 Replies View RelatedIm a fairly basic VBA user who has just purchased the code for J-Walk's Enhanced Data Form.
On other threads in this forum I have noticed a lot of people asking how to make the contents of one drop-down box dependant on the selection in another. I am trying to do the same thing but with the criteria section of the EDF form.
Is this possible? What does give me hope is that a simple Autofilter - whilst not as aesthetically pleasing, does the job well.
Currently I have columns fixed or assigned to the names of insurance providers/companies.
In each column below the name of the Insurance Company, a combobox containing the plans that company offers. Choose a plan, and the rest of the column is filled in using vlookup.
Now to save space, IE opposed to having 13-15 columns one assigned to each Insurance Company/Provider. I am looking to have only 3-5 columns with a first initial combobox in which one chooses the Name of the Company/Provider, and in turn populate the original combobox and vlookup functionality I already have built in.
Here is an example of what I am working with.
[url]
I need help to create a formula that would grab data from one sheet and populate another sheet based on the employee that is selected from a drop down list.
Attached is a draft of what I am looking to do.
Basically this would allow us to enter employee variances from several employees on one sheet and get a detailed break down of their history on another sheet.
I want to have a drop down list in a cell so that the value in the cell can be only selected from two columns of data. Additionally once the data from the first column has been selected I want to be able to limit the inputs the user can select from in the second column.
e.g. In cell C115 I want to have the value BDS05.
I want to be able to select the value BDS from a drop down list of values and once that value has been selected I want to be able select 05 from a list of values from 01 to 14
If I select BCS as the first value then I want the second set of values to be limited to 01 to 02 etc.
I have read about combo boxes and list boxes and I'm a bit confused about the best way to achieve this (or even if I can).
I'm trying to do some userform development with multiple dependent comboboxes, but I am having trouble populating the third and last combobox. First, I populate the 1st combobox on the userform initialization. I can get the first 2 comboboxes to populate correctly, but I can't seem to get the 3rd combobox to populate correctly.
The 3rd combobox takes the selection from the 2nd combobox and searches column "A" in the worksheet "Chassis Specs" and populates the 3rd combobox with data from column "B", there will be repeat items in column "A", but all those occurances should populate the 3rd combobox with the data from "B".
I am attaching my whole workbook.
Chassis Specs Info_Build_REV B.xlsm
I am creating a Userform and one of the elements on it is a combobox where the user has to select their name. On the same Userform, I want to have a textbox (or listbox or another combo box if necessary) which will show the users default cost centre based on the initial combobox selection. I've tried doing this various ways, but I can't get the textbox to update when the combobox selection changes.
View 7 Replies View RelatedI would like to do is have 2 listboxes. In the first listbox I would like the name of all the worksheets which contain the words "elective class: " in cell C7.
In the second listbox I would like the name of all the worksheets which do not contain the words "elective class: " in C7. I need this only to source from worksheet 7 onwards however.
The listboxes are called ListBox1 and ListBox2 respectively.
Also I am using this to print and I have a button which currently selects all the data in the first listbox and another button which prints all the selected data. The code being used for this is:
I have a dashboard that uses three pivots based off of a single data source. Each of the pivots is designed to work off of their own drop down list.
the first drop down list allows the user to select a lease date. The associated pivot will update with all servers assocated with that lease date.
the second drop down list allows the user to select a server. This list is limited by the lease date selected in the first drop down. The associated pivot will update with the partition information for the server selected in the drop down.
the third drop down list allows the user to select a partition. This list is limited by the server selected in the second drop down. The associated pivot will update with the detailed partition data for the partition selected in the drop down.
All of the above works, the issue is that when a new lease date is selected in the first drop down list, the current entries for the second and third drop down list are still reflecting the old lease date information. When you click the drop down the correct data is there, it is just not automatically populated.
Is there a way that when the user selects a new lease date in drop down one, the first server in the new list is automatically populated in the second drop down as well as the first partition in the third drop down?
How do I change the color of a row, based on the users selection from a drop down box in that row? I have four driving types in my drop down , Towing - Town Driving - All highway - Mixed. I would like each driving type, if selected, to change the color of the entire Row of Data to a different color. I have been able to use conditional formating to change the drop down cell itself, but that is it.
View 1 Replies View RelatedI have a shared worksheet that has many rows of data... but only certain rows are relevant to each specific users. I would like each user to be able to select their name from a drop-down list in order to have all rows that are not important to them be hidden. I can put the name of the user in column 'A' in each row they need to see, but how could I make all rows that do not contain their name in column 'A' hide? In other words, if 'Bill' is selected from a drop-down list, only rows that contain 'Bill' in column 'A' would be seen.
View 9 Replies View Relatedhow to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box.
Example:
If Fat, Use range from C6:C7
If Skinny, Use range from D6:D7
Note: I tried putting an if statement in the input range for box2 but won't accept it.
I have a workbook consisting of 5 sheets.
Sheet 1 is the master sheet, and (among many other columns) it has a series of yes/no columns. The yes/no options are the equivalent of:
"Are you in sheet 2?"
"Are you in sheet 3?"
etc.
When this is the Yes option, I would like the rest of the contents of the row to copy into sheet 2.
These need to remain linked, so if I change stuff in Sheet 1 I would like it to change everywhere.
I have a pricing model I'm working on where the request is to have all of the line/part items in the model, but only display a subset of those items based upon a sub-line chosen by the user by a drop box that includes all sub-lines.
Right now the list of parts is a table that I'm querying that also includes a simple '1' or '0' to indicate whether every part is an element of one or many sub-lines; eg (sorry, sure this won't format right):
Item SubA SubB SubC
210-1010 1 1 0
210-1011 1 0 1
So if choosing SubB in the drop box, I need the autofilter to show the first part, but not the second one. I think I have to do it this way (autofilter) because it will retain all of the parts whether the user is looking at them at this moment or not; they will use this tool to perhaps first price all SubB items, *then* go select SubC and price all of *those* items - and it needs to retain everything they've done, rather than a dynamic query that would lose prior changes and pull in a whole new set of data (if that makes sense).
So.... I need my autofilter to react not to specifically choosing data on the autofilter itself, but to a choice made in the drop box (probably a macro/VB attached to the box that reacts to the linked cell value that results from the choice, but I don't know how to tell it if the linked cell value is '5', go to column 7 (first two are part number and description) in the autofilter and filter on that column.
Attached is the file i am working with. The table spanning from A:AA5:16 contains hours worked per day of the week with respect to the Project chosen from the drop down menus in A7:16. Cells in the range of F,K,O,R,U,X,AA7:16 total those hours worked on a daily basis. The table below should sum the total hours worked per day according to the Project selected in A19 from the drop down menu, with respect to the Project(s) chosen in cell range A7:16. For example, if i am looking for total hours worked Monday on Project RSB i select "RSB" from the drop down menu in cell A19, i want cell F18:19 to be the sum of cells A7 and A9, with respect to the Project selected from cells A7:16. If I select "FRG" from the drop down in cell A19, i want cell F18:19 to reflect the sum of cells F8 and F10.
View 2 Replies View RelatedI have created a pricing sensitivity for a list of products. In cell C3, users can select a product (i.e. Apple, Elmo, or Bowl) and based on this selection, a range of Prices and Units are then updated and the Revenue for each price point calculated. A few lines beneath this, I have a little summary table that lists all the products. I'd like for users to be able to enter in the optimal price point for each item and then have the Units and Revenue for that selected price point for that specific product automatically update.
For example, if I select Apple from my drop down list my price choices are $5, $10, $15; units are 100, 85, 70; and revenue are $500, $850, and $1,050 respectively. On the summary table, I would like units 85, revenue $850 to update automatically if I select/input a $10 price. This would happen for all the products so at the end I want to be able to calculate a blended revenue mix given my pricing changes.
I have created a User Form that has been tested and is working properly. Now my last step is to do the following:
I would like to Display the User Form (coded as CommRM) if in Column C (can be any cell as it is a large worksheet) someone selects "Retail News" from the drop down option.
The code that I have been able to create so far is below. The problem is that when I select Retail News from a drop down in Column C the user form does not appear.
VB:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range (C14, C3333).Text = "Retail News" Then Call UserForm_Initialize
End Sub
Private Sub UserForm_Initialize()
Load CommRM
CommRM.Show
End Sub
I have a excel file to keep track of sales pipeline. What I am looking for, is an automated utility or code that will allow excel to automatically move entire rows once a task is completed and can be moved to another sheet. In Prospects sheet I have a column for " Stage" and here you have to select from a drop down menu, either "Prospect", "Contacted" "quoted" "WON" "LOST" What I would like, is that once you have selected one of the sales stage, the entire row or entry, will be automatically moved to the right tab from the "prospects" to a new sheet according to each stage.
SalesPipeline.xlsx
I am trying to develop a worksheet that will adjust dates based on a selection from a drop down box. I can do basic formulas in excel
I am trying to get the drop down box in "Revisit Type" to include three selections ("Sanitation", "Spark", and "High Five"). Once the dropdown box is created I want to be able to make a selection and enter an initial visit date under "Initial Visit Date" then have the "Earliest Return Visit Date" and the "Latest Return Visit Date" automatically populated based on this information below:
Sanitation or Spark = 10-30 day window
High Five = 10-21 day window
I am at a loss . I have attached a sample of the workbook for reference.
Sheet 1 has a table of prices. There are 7 columns labelled 2 thru 8 and two rows, labelled 1 and 2. Each combo has a separate price.
Sheet 2 has a weight specification (1 or 2 referring to the rows in sheet 1) and a drop down menu with options 2 thru 8.
When I choose a number from the drop down menu, let's say 5, I want to populate another cell with the value from sheet 1 of column 5 on row "whatever the weight spec is", let's say 2.
I'm wondering how I could display information based on the user input through dropdown selection. I know how to make a dropdown-list already.
Example: A1 has a dropdownlist with Apple and Banana in it. If I select banana then I want B1 to display "8" and if I select Banana I want B1 to display "4".
Changing the data based on a drop down selection. My drop down list is based on the months I need the data (percentages for each person) to change depending on which month is chosen. So If I select Jan, the percentage fills in for each person. I've attached an example.
View 3 Replies View RelatedI am trying to create a spreadsheet which allows me to select an antibiotic from a drop-down menu (refer to cell D1) on Sheet 1.jpg, which would then color the cells below based on the color-coded coverage based on another sheet (refer to D2-D17 of Sheet 2.jpg).
View 10 Replies View RelatedI have a shared worksheet that has many rows of data... but only certain rows are relevant to each specific users. I would like each user to be able to select their name from a drop-down list in order to have all rows that are not important to them be hidden. I can put the name of the user in column 'A' in each row they need to see, but how could I make all rows that do not contain their name in column 'A' hide? In other words, if 'Bill' is selected from a drop-down list, only rows that contain 'Bill' in column 'A' would be seen.
View 9 Replies View RelatedI found many examples on this forum of how one can pull in data from closed workbooks, or copy it and have it stored in the active sheet. So far so good, but I need a solution which would do the opposite - I need the macro to take a range of data form the active sheet store it in a closed workbook and save any changes in the target workbook without opening it.
View 2 Replies View RelatedI am trying to use a row of cells as update cells, where the user inputs an amount into greyed out cells, which in turn updates Sheet1!$I$2:$I$11, from which it will update other worksheets that are currently in progress. but I do not know how to go about it. Is it possible?
For each amount the user enters (for each Code Number) a date will be displayed below the amount.
I need VBA code to do the following:
When cell H2 = "Weekly", I need cell I2 to return "50".
When cell H2 = "Bi-weekly", I need cell I2 to return "25".
The value in Column I should change as soon as the value in Column H changes.
NOTE: The value in Column H is chosen from a Data Validation List.
I'm assuming offset is the best option?