chosen

so let's try this again. I'm trying to get a specific drop down list when a specific category of expenses is chosen. in cell F13 I have a drop down list with Office, Exec and Conf/Mtg What I would like to achieve here is that in cell I13 a drop down menu will populate according to what the...

Hi, I have an excel template which can be used by different users. I would like to have a macro that expands or collapses a group of cells when a specific user-type is chosen in a "user" dropdown. Details: Dropdown is found in cell A4 and has option of choosing user A or user B. If user A...

Hello How to place a large data block at a chosen cell I know I can copy the range and paste it at the chosen location, but I would like to simply use block = Range("BB1:CC50") Range("A1").value=block currently all I get is the first cell into A1. I would like the entire block to appear...

Hey Excel Gurus, I want to shade a row based on the value in column I. There are sequences of values in column I. for example column I 5D 5D 5D 8X 8X 2M 9M So Rows 1 to 3 meaning 5D should be no color, 4 to 5 meaning 8X should be the chosen color from formatting. 2M no color. 9M same chosen...

Hi I would like to have a drop down, 2 of them where the second one the options changed according to the option selected in the first drop down. For e.g. Dropdown 1. Drop down 2 Mike. If chosen Mike 24 Joseph. If chosen Joseph 15 Thanks

I currently have a userform which the user choses a selection from the Combobox and the other textboxes populate data dependant on what was chosen, this all goes well however I am unable to get the listbox populated. The listbox data (named ranges) are on a different sheet called SITES (Column C...

Hello friends, hope all is well! Please help with code; I am getting: VBA Runtime Error 1004 “Application-defined or Object-defined error”. I am trying to choose / filter the row field, from the range A1:A100 of sheet2. so whatever is in range A1:A100 will impact and chosen to filter the...

Ok I haven't a clue what to search for to see if this has been asked. I finally bit the bullet and started migrating my Approach databases to Access. I have quite a few questions but I will go for one at a time. This one is a recipe database for whatever its worth. I want to select a recipe...

Hi there, My question: How do I restrict the user from manually typing the "%" symbol in a cell?? Background: I'm trying to finish a basic user form (with drop-down lists) where: - if option 1 is chosen in cell A1, then cell A2 is formatted in Accounting format. - if option 2 is chosen in...

Hi Hope you can help me below is a formula that is in 4 different cells obviously recalling a clients data into cells once the client number is chosen in E4, what I need is to adjust it so that if there is no client chosen yet in E4 that the corresponding cells be blank and not have the #n/a in...

Hello, I am trying to create a vba that will allow a user to enter his chosen date in the dialog box (eg. 20160730), then open a file from the previous month of his chosen date, as there is only 1 file per month in the folder (eg. 20160630_country.xlsm), and rename this file using the user's...

Apologies for not knowing what this may be. I have the following table and am trying to figure out if excel is even capable of indexing some value. Each number on top has 2 categories. If the desired number chosen is 34, the result should be 30 and 40 for example. If 30 is chosen, the 10 and...

I am trying to create a formula when cell H6 (validation criteria – drop down list) – Semester (text) is chosen another cell H20 (drop down also) defaults to 1 and locks the cell (H20) so that other options in the list are not available when H6 (Semester) is chosen from the drop-down list. How...

Hey everybody, Glad to meet you. I have the following question and I will be glad if someone can help me with it. Thanks in advance. If you right click a cell and go to "format cells" The first tab is "number" From there, you can tell it to treat it as a currency date number etc And then...

Hi All! I am attempting to create a pop up message box when a user closes the spreadsheet. I'd like it to function by: 1. Showing the Yes/No message box when the user attempts to close the sheet. 2. Send user to a link (google doc) if Yes is chosen. 3. Close sheet if No is chosen. Here is...

Hi I'm not sure if this is possible with excel but I am currently trying to simulate a reinforced learning algorithm using formulas. Basically what i am trying to do is automate a sheet whereby every time i press f9, an iterative calculation will be done in worksheet 1 and from there the...

Hi, I have a scenario where I have a dropdown box in column K (using data validation) giving options of different types of unit that are available to hire, in column M there is a list of hire periods (1-2 days, a week, a month etc). I have a formula in column N that looks at these cells and...

<tbody> B C D E 1 Date Market Spent 2 01.01.2017 Roda $1500 3 01.01.2017 Roda $500 4 01.01.2017 Maxi $1000 5 02.01.2017 Roda $740 </tbody> I try with =sumif, but it sum all on roda. What function to use to get how much money i spend in chosen market (1st criteria) on chosen...

Hi, Not sure how to do this, but I have one cell who's number value is taken from a drop-down list. I need a corresponding cell to equal a text value depending upon the number chosen. Can somebody please let me know how to do this Thank you in advance

Hi guys I was wondering if you can help with an enquiry I have a sheet that has a drop down box The box has selections like Coke Pepsi Fanta Etc I was looking for a formula that will count the number of times a drop down is used, not fussed on what is chosen So for example If Fanta is...