drop

Hi Friends, I have a list of data where I have 2 drop Down based on Region and Name. Is there any possibility that Only the Specific User can access his own specific data. I don't want them to view the complete list. Regards Rahul Nair

I have a WookBook with 2 sheets. It's being used for keeping track of some temp badges for our work place. Column A has the Temp Badge # and highlighted red or green if there is a name in column c. Column C is a Name field Column E is Date and auto genrated when a name is placed in Column C...

Hoping someone can help with this topic. I have a drop down that has 24 items that are always rolling or being updated. I'm looking for a way to filter on the last 12.

Hey Guys ! Can any one help me out, i am stuck with a problem I have a list of codes in Sheet1 from A1:A1000 I want that list to populate as list ( Data Validiation ) in Sheet2 from B1:B1000 ( but from B1 to B1000 the list should be searchable ). As in when B2 is selected then selecting codes...

How to drop down list (data validation ) automatically when cell is selected ? How to make the list ( data validation ) searchable ?

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 currently have a ComboBox drop down on my worksheet which when i click on the drop down i see the list of customers from A-Z in the order of First name then Surname. I need the same but Surname then First name. I have copied the existing code & changed the relevant items but need some...

Hi All, I am attempting to create a spreadsheet and would like to know if it is possible if somebody selects "yes" from a drop menu options of "yes/no" that the row is automatically copied from one worksheet to another that is password protected? I want the first sheet to accumulate the workflow...

How can I set a drop down list to a blank cell, but not to see the little arrow of the list? I mean, when you want to write in the cell, when you click in the blank area, the list will drop. Thanks.

After I fill in the three boxes with drop downs I have a pop up after I click the enter button with a message that says Qualification....Please select the inspection type from drop down. It highlights that box in red and populates this long number in the box. I'm not sure where the number...

Hi MrExcel, I'm fairly new to VBA and macros in Excel and could use more than some help with it! Currently i'm working on creating a report where i have a drop down list of countries (in cell C2) with the list of countries (in column A) and their datas across row A7 to S65. I would love to know...

I've built a financial modeling stencil that is used for underwriting. The stencil has tables, charts, and exhibits that are imported into the finished word doc. We use the stencil for multiple clients with varying color schemes. I'd like the background colors of specific cells through out the...

Morning, I have a userform which has many comboboxes with drop down lists. I have noticed that if a drop down list entry only shows N/A then below it is a blank entry also. Anything else where there are 2,3 or 20 options to select then the blank space at the end isnt shown. The sheet where my...

In column say column A If have put a drop down list from which the values may be selected If anyone types some thing the entry gets rejected, but if some one simply drags the value from above sells it works. How do I prevent this and force the person to select from the drop down list

Good afternoon, I need the code for a macro that will select an item from a validated drop down list and then break whilst a form populated from a database is populated. This then needs top reapeat 200+ times cycling to the bottom of the list until there is no more data to pull through. I...

Hello, I'm trying to weight a score so that the closer it is to the top the smaller the increments are. For example, if someone scored 2.1 then they would get 100, if they get 2.5 then say 99, then 3.5 might be 96 etc. the further away you get from 2.5 the more severe the drop in score. When...

I have set up a drop down list on a sheet using Data Validation. I am now trying to reference the selection that will be made in the drop down on a separate sheet in the same workbook, but when I do so I receive an #VALUE ! error. Note, that if I reference the selection in the drop down on the...

<tbody> QTY Description Sub-category Rate Total 1 sprinkler £ £ 1 pipe £ £ 1 labour £ £ 1 design £ £ 1 hangers £ £ </tbody> So, I'm working on a spread sheet for work but hit a bit of a wall. I’ve got part of this spread sheet to work. This is...

Ok i have asked this question already before but i have gotten no where. I have simple standard cell that i enter a Name, Company, City/State, phone, and email. I would like for that information to be transferred to a table on a different sheet. I then want to use the name cell from the first...

I have a userform ComboBox that pulls drop down list from Col A of another sheet in workbook. This list in Col A is constantly added to manually. i.e. I have new clients to add. How can I avoid adding new clients manually in order to show up when using the userform ComboBox. What code can I...