I am trying to calculate phone call rates based on several different conditions. *if my phone call has a "DESCRIPTION" of "Local" then I want to add 2 cents onto the "COST" *if my phone call has a DESCRIPTION of "Mobile" then I want to use the formula = SUM(G7*24*60)*0.4+0.1 to calculate the charges *if my phone call has a "DESCRIPTION" of "13 Number" then I want to add 5 cents onto the "COST" I am able to use a formula that allows 2 condition but I have been unable to work out a formula where I can add more conditions.
I have attached a spreadsheet
When I try to insert an 'option' box in which either a check box or radio button are used, only one option can be used. For each option I have to create a new option. But then, each option can be selected, which defeats my purpose. I want to create an option box where there are two option in the box, but the user can only select one of the options, not both, or neither.
I am working on a grading sheet for our company. I would like users to choose from an option button choice (A, B, C, D, F) for each grading category and I would like to write that to a sheet that corresponds with the graded person. The form will have next and previous buttons to move through the grading process - when previous is chosen I would like the option buttons to populate what was stored in the data sheet. I think I can mottle thru the code individually but with 60 option buttons it may take quite some time.
Can I call an option button choice by "Group"? I started coding individually, but it will take a lot of code - surely there is a more efficient answer. A picture of my form is attached at the bottom of this post.
VB: Private Sub OptionButton1_Click()Dim Grade As String If Me.OptionButton1 = "A" Then Grade = "A" Else Grade = "" End If
I am trying to create a simple order entry worksheet. In cell M1 I need a dropdown box that lets the user select which options go on the product. You can have multiple options. The list of options is contained in column A of the Options worksheet. Depending on which options are selected, I want to put a 1 in column B of the Options worksheet. how to do this or have a sample workbook that I can look at.
I am having a problem with some code I am trying to work with. My problem is that I need to source information which is selected on a userform in 3 list boxes and copy this information into the excel sheet behind on the same row.
I am looking to create a spreadsheet wherein the user can choose multiple drop downs in sequence and then have it output each choice to a template or empty space within the spreadsheet.
For example, lets say column 1 said what is your favourite colour and had a dropdown with two choices red and green. Column 2 says "favourite place" and had a drop down with two choices "London and USA". Then once the user chooses an answer in each column it would output these choices to notepad or a large space within the spreedsheet.
In this example it would output:
"Red London"
if the first two answers were chosen from each column. Obviously it would be a much larger scale than the simple example above.
I have here an example of how I might extract data from a source workbook and paste it onto a template workbook, using autofilter to find the rows that are needed. It is currently set-up to take rows that match "AREA 1" or "AREA 2" in column A, along with a number of other criteria in other columns.
What I want to do is add into this macro, a way for the user to be able to choose the filter options will be used for column A of the source workbook. So if they want only "AREA 1", they can choose just that, or if they want "AREA 2", or perhaps both "AREA 1" & "AREA 2", or further additional options. They need to be able to specify just one, multiple, or all of the filter options with regards to column A of the source data.
In effect what I need is a user input box or form with a dropdown menu that will give the filter choices based on column A of the source data, and then for the code that copies the data across, to do so based on which choices the user makes in the filter menu of the input box.
I have uploaded examples of the source data workbook and the target template workbook. The macro exists within the template workbook.
[Code] .....
How it may be possible for the user to be able to specify, one, multiple, or all available filter options for column A of the source data, via a user input box or form.
I've created a simple dynamic chart using a combination of data validation and an index match match formula. Every time the user makes a choice the chart updates with the right info. However is there a way to create a choice where the user can show *all* the choices at once on the chart ?
I am trying to create a simple user interface type thing so that someone is able to select from drop down lists someones information, such as whether they are male or female, aged between 19-35 or 35-67, whether they are studying in a business area, legal or construction etc (there are 6 variables in total), This will then give the probability of success of the person passing this course based on probabilities which I have already worked out. I have worked out how to do the first stage of creating a drop down list showing alternative choices with Sex, Age etc in the data validation options, however:
There are 517 possible combinations, as in Male aged 19 to 35 studying Business (with other variables) or Male aged 19 to 35 studying Law (+ other variables) etc etc etc each with their own probability of success. Due to the long nature of writing out Male1935BusinessNorthWestWhiteBritishCollegeBrown I have rewritten it so it appears in the excel file as M1935BNWWBCB, which obviously wouldn't make any sense to someone if they had to select M 1935 B NW WB CB from drop down lists.
Along side the M1935BNWWBCB there is the probability of success specific to that type of person. So for example I could would have: M 60% M1935 64% M1935B 35%....
I'm trying to write a formula for the following simple situation. Eventually I will need to use this formula for several hundred people with several hundred choices.
Like I said, this is a simplified example that I will eventually need to expand out to hundreds of people. Lets say I have 5 people, we will call them #1, #2, etc to #5 and I have 5 cars, red, blue, black etc. Person #1 gets his first choice, person number 2 gets second choice etc. But if person #2's first choice is the same as person #1's, obviously he can't have that choice and must go to his second choice. Some people may not have a preference and won't get assigned any color.
I'm trying to find a way to make the user select only one of five columns in a row. What I’m trying to get is a ranking of 1 to 5. The user will click a cell and it will fill in or the user puts an X in it. In row 8 I want to select A through E but only one of them. If the user changes their mind and clicks another cell, the first cell clears.
I am trying to assign rooms to tenants. I would like to set up a function that reads a tenant's top 5 choices for a room, and looks up a column to see if the choice has already been selected before moving to the next choice. Then if all 5 choices have already been selected, the cell reads error.
I have 2 columns "H" and "I" from line 6 to 409. Each cell may start with AR , MA or a number. If cell H6 starts with AR I would like to put that cell into B6. If H6 does not have AR then I would like to check I6 for AR, and put that into B6 if it's found. If I don't find AR in either I would check them both for MA, and write the cell that finds MA into B6. If the AR or MA are not found then I would want it left blank. I did try
IF(FIND("AR",$H7,1),$H7,IF(FIND("AR",$I7,1),$I7,IF(FIND("MA",$H7,1),$H7,IF(FIND("MA",$I7,1),$I7," ")))) in B7.
Lets say I have 20 cells. I want to randomly assign a label to the each cell from 5 choices, like "Blue", "Orange", "White", "Green", and "Black". But I want to assign a probability of selecting the labels. So the percent probability of choosing Blue would be 56% and White would be 23%, etc. . . is there a function that allows me to do this?
I have a series of macros altering various workbooks and sheets. They're numbered Step1, Step2, etc. In my Step5 I have a series of Case statements in a macro, and I don't know how to get it to do what I want next. I have NOT tried running this code yet, and I'm sure I have something(s) wrong in it.
1) If the selection in DstWbk, sheet "Steps", is "01DSP" through "11DSP" the macro needs to delete specific columns in the SrcWbk, and then move to the next step (6).
2) If the selection in DstWbk, sheet "Steps", is "*DSP" the macro needs to go directly to the next step (6)
3) If the selection in DstWbk, sheet "Steps", is anything else the macro needs to flash a generic "No Data found" message and move on to Step7.
The part of the code that's throwing me begins at 'Select only the specific regional data' and ends at the "Case Else MsgBox"
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.
I am writing a simple application that allows users to enter an item ID and execute a find. If the data is found, the UserForm populates with the pertinent data for the requested ID otherwise a message indicates Item not on file. The file being interrogated is an Excel workbook with multiple functions, unrelated to my task.
The problem: When my application opens the workbook to perform the Find, the screen displays a message generated by Excel, informing the user that the workbook contains links to other data sources and requesting to choose to either Update or Don't Update those links.
I used the Application.DisplayAlerts=False line but it has no effect on above. The choice I always make is Don't Update and the macro continues to the end without further ados.
Is there a way to either cancel such a screen request or automatically select a given option?
I am trying to create a msgprompt but instead of using the default yes or no, I need 3 options, so if the user clicks the first option, it will check a certain box. It will look like this.
I am making a program that needs some macro but I don't know much about it. There are a couple of things I am trying to accomplish and I'm supposing it would be easier to let you look at the actual program so I uploaded it.
In the drop down boxes in column C there are trucking companies listed. Each trucking company has different trucks with different numbers that pull different numbered trailers. When I select say, "T & L" from list c8 I need the lists in that row E8 & G8 to display only the information related to that trucking company and no others (as opposed to every trailer number and truck number on the lists in row 100). Only T&L drives a truck with the number 08 pulling a trailer with the number 564, etc. I need the same thing to happen for the truck list E8. When a particular truck is selected the lists in g8 narrow to the numbers of the trailers that that truck have pulled in before. So e8 (truck number 88) makes g8 list trailers 8855 and 8445 because that driver only pulls those trailers.
If you can kindly help me with that macro to work for a sheets in the workbook that would help a lot. The only thing is it's useless unless the program can learn new trucking company names with their respective trailers and trucks (we get new ones sometimes). I created the "ADD" sheet to be able to add new trucks, trailers, carriers (companies) and employees. If c8 doesn't have say "t&L" trucking company in it I can go to the add tab and type into cell a4 the carrier, d4 trailer number, g4 truck number, etc. I need that information to add itself to my list on the "page 1" tab into the orange colored list a100:a200 while the trailer goes to e100 and truck c100. The above paragraphs macro would then be able to sort the data in the list when a carrier is selected.
i have this code to populate the worksheet from listbox selections, but it only works on a 'one at a time' basis.
Private sub cb1_click() Dim i As Integer Dim Ltm As String
With ListBox1 For i = 0 To .ListCount - 1 If .Selected(i) = True Then If Ltm = "" Then Ltm = .List(i) Else Ltm = Ltm & ", " & .List(i) End If End If Next i End With
With ActiveSheet .Range("B" & .Rows.Count).End(xlUp). _ Offset(1, 0).Value = Ltm End With For i = 0 To ListBox1.ListCount - 1 ListBox1.Selected(i) = False Next
what i am trying to do is once i have checked several items in the listbox is have all of the checked choices fill iin column B at once.
I have multiple choices in a list box. I wish to know how do i link each choices in the list box to another worksheet so when clicked it goes to the worksheet specified.
I refer to the following article from last year, with a similar question. Multiple Selections Drop down list to one cell.
I would like to be able to choose multiple values from a list box and print them into one cell (or at least print them anywhere).
For example: I have a list with products A, B, C, D, E, F Those products are shown in the list box. If e.g. B, D and E are chosen, I would like to have this selection shown together in another cell. That means the content of the cell should be "B, D, E".
If I use the INDEX function (which works fine for single select list boxes), only one of the selected items is displayed in the cell and not even the one I selected.
code to loop and fill the attached worksheet Slot column with the techs first choice that is not a duplicate above from more senior tech. The techs are listed down column A with the most senior tech able to get first choice. If the next tech down the list bid the same choice as the first tech the the code would select the next choice.
Column D has a list with the choices OPEN, PENDING, CLOSED. I want Column E to automatically enter the date when someone choose closed in Column D. So in Cell E6. I wrote, IF(D6="Closed",Today(),"") . . . . .
It works, but wondering if E6 will keep changing the day every day to show the current day (bad) If so, how do it get it keep the closed date?
I have a saved file at d: named Report.xls from another file I am copying column and pasting data to this report file, this is done by a macro. While pasting data to the report file, a pop up message is coming up – A file named D: eport.xls already exists in this location? Do you want to replace it?
In case “yes” is clicked it pastes the data But the problem is that the macro that I have in the report.xls vanishes. The macro I need in the report.xls?