Dropdown Menu To Automatically Update Other Cell
Dec 20, 2012
I am trying to create a job data sheet as per below. Under 'Sales Item' I have a drop down menu to select the item sold. I am trying to set up an autofill formula to fill the 'Stock Cost' cell once we have selected the relevant product from the drop down menu. The data is on another worksheet on another tab at the bottom of the sheet.
Sales Item
Sale Price
Stock Cost
Profit Per Item
Installation Commission
£0.00
£0.00
£0.00
£0.00
[Code] .....
View 2 Replies
ADVERTISEMENT
Jan 13, 2013
I am creating a very simple spreadsheet to manage my gym memberships. It basically has membership number, first name, last name, membership type (drop down box) start date and expiry date. I have put in conditional formatting so that the expiry date goes red when expired but i want to try and automate the inputting of the dates so for example.
If i select '1 week membership) from the drop down box in the membership type box it will firstly change the start date to the current date (i think this is using the NOW() function) and secodnly changes the expriry date to todays date plus 6 days. Ofcourse i want the expiry date to increase depending on the selection so if i select 1 month membership it would be now date plus 28 days.
I am stuck as to how i can do this and from internet tutorials have been told it requires macro as it cant be done any other way?
View 14 Replies
View Related
Jul 7, 2014
I've got a workbook with multiple worksheets related to several subsidiary companies for each state & territory, resulting in 450+ worksheets in the workbook. I created a summary sheet with a dropdown menu for each state/territory that pulls in the relevant data using "=indirect". For example, selecting CA from the dropdown menu populates the combined revenue, expenses, etc., for all subsidiaries in CA. However, I've got 50 states plus some territories. I'd like the revenue, expenses, etc. for every dropdown option. Ideally, a separate sheet (or whatever) that lists all 50 states and the revenue, expenses, etc., for each one below (or across).
Is there any way to do this automatically so I don't have to select every single option and copy and paste the numbers into a different worksheet?
View 1 Replies
View Related
Jan 29, 2013
I would like to Use two drop down list with two set of information to automatically update fields.
I have Job Titles (1-6) and Step (1-5). Each Job Title has a new pay rate and each step is an increase in pay. What I am trying to do is set up a drop down list where some one can drop down Job Title and step and have the rate automatically fill in.
I am able to get the Job title to auto fill the rate field, but am having trouble incorporating the step into the formula.
Here is what i currently have:
=VLOOKUP(H6,'Pay Rate'!$B$2:$G$12,3,FALSE)
H6 = Job tilte field on 'WorkSheet' (Sheet1)
'Pay Rate'!$B$2:$G$12 = Sheet2 and Step increases per Job Title
3 = the current column I was working with in order to make the rate appear
False = for exact info
I do not want to combine the two columns but keep them separate drop down list.
View 4 Replies
View Related
Oct 18, 2013
Let's say that in column A I have numbers,"Yes" and "No". I want in column B to have only the numbers from column A, in the same order without any empty ranges, and everytime I add in column A a new number, column B to update automatically with that number. Let's have an example:
A B
Yes 12
12 13
No 10
13
No
10
Yes
And if I want to add in column A:
A B
Yes 12
12 13
No 10
13 25
No 15
10
Yes
25
15
So the column be will update automatically. I already tried =IFERROR(INDEX($A$1:$A$10,SMALL(IF(ISNUMBER($A$1:$A$10),ROW($A$1:$A$10)),ROWS(B$1:B1))-ROW($A$1)+1),") but using this many times get's my file very heavy and the excel is working slow.
View 13 Replies
View Related
Jan 14, 2013
Need to create a drop down menu for a cell that allows selection of 1 of the 5 to 10 alternatives by clicking on an item in the drop down. Have seen this done by attaching a down arrow button to the cell.
What is this feature called, and how do I go about setting this up?
View 1 Replies
View Related
Aug 13, 2013
I want to select Work Type and it will then look at the list data and auto fill the highlight cells.
View 5 Replies
View Related
Jul 29, 2013
Is it possible to display only one character when using drop down menu? For example, if the drop down choices are A=...., B=...., etc., is it possible to only display the A or B in the cell after you've made your selection?
The purpose of this spreadsheet is to obtain data that will be entered into an application. So it would be very useful if it could be printed on one page - and the columns only show A, B, C, etc. Also, as it is now, the spreadsheet is difficult to work on because there is so much visible text.
View 1 Replies
View Related
Dec 17, 2009
Hey everyone, I'm new to the boards and only moderately familiar with Excel, so I'm looking for a little help. My question might not be completely clear, so I'll try to give you a visualization.
I want to give users the ability to choose different kinds of expenses from a drop down menu (i.e., Salary, Postage, Supplies). However, some of the expenses have general costs associated with them on top of other costs, and I want it to be made clear by having the proper costs come up with the proper expense. For example: ...
View 14 Replies
View Related
Jun 3, 2014
Ok, so I have a sheet with a working drop down list with dates, and depending on the date you choose, certain columns getting hidden and some un hidden. The layout is the same form is repeated 7 times, and which ever date you pick, the corresponding form gets un hidden. My question is, I have a button that will export it to a new sheet with just the values, to be sent to the office. I don't need to send the entire work book and confuse people.
I know how to export, just not using an if then to choose which columns to export.
sample: Attachment 322549
fixed the attachment: added my codes
View 4 Replies
View Related
May 31, 2012
I have a workbook with two sheets. The idea behind the workbook is an Interview Guide to be used just before an Interview. For now my problem is this.
Sheet 2 "Competencies" is just data. It stores competencies with their associated definitions and questions.
Sheet 1 "Control Page" is the sheet where the questions will eventually go. The user (Interviewer) will input data on the first two pages which will include name of candidate, date of interview etc. but they will also select 5 Competencies from the already existing drop down menus on page two. From there as the selections are made I wish for a code to copy the corresponding definition on sheet 'Competencies" to cells lower down in sheet "Control page".
I don't see a place to upload a file as I have a sample of the sheet ready to go.
View 2 Replies
View Related
Nov 25, 2013
i am making a simple complaint tracking system and there is a column where there are two choices Resolved and Unresolved if you choose resolved it copies the row to the resolved sheet and if it's unresolved it copies the row to the unresolved sheet. i attached a template to give you an idea, i want the first complaint to be copied to the resolved sheet and second one to the unresloved sheet, i don't want the status column which contains the choices to be copied to the other sheets, also the unresolved sheet doesn't have a 'date closed' column because the complaint is not yet resolved so i dont want it to be copied there, i want it only in the resolved sheet.
[URL]
View 1 Replies
View Related
Dec 11, 2008
I have a basic formula =C17+'Asset Depreciation 2008 Onwards'!C24, and I want to copy it down just using the drag function. Problem is that the second reference range of cells are in rows and hence when I copy it down it doesn’t automatically update the cell references because it want to update them by column number instead of row number. IE I want it to display =C17+'Asset Depreciation 2008 Onwards'!
D24, instead of C25. Do you know if there is any way of telling Excel that I want it to increase the column number by 1 every time, instead of the row number for this part of the formula?
View 5 Replies
View Related
Feb 19, 2014
I have a large workbook, with multiple sheets. I would like to be able to select a name from a drop down menu, and have the cell color change for all entries of that name in my other sheets. I can do it manually, but it would be much cleaner and easier to have Excel do it for me. I have looked at other answers here on this forum and know that if it can be done,
View 1 Replies
View Related
Jan 2, 2010
I am trying to create a simple scoring system for sports that use a "legs" and "sets" format (e.g. tennis, darts etc.)
I would like the "sets" cell to automatically update as the "legs" cell reaches the required amount of legs to win a set. After that I would like the "sets" cell to continue to count upwards when/if another set is won. Is this possible?
View 9 Replies
View Related
Dec 20, 2013
Lets say I have two sheets titled "dashboard" and "raw data" in a workbook. Cell A1 in "dashboard" should always show the most up to date data from Row 1 in "Raw Data".
I update "raw data" daily, adding a new column to Row 1. For example December 19 would be A1, December 20 would be B1, December 21 would be C1 etc...How can cell A1 in "Dashboard" always reference the newest cell in Row 1 of "raw data"?
View 2 Replies
View Related
Mar 1, 2008
Is is possible to have Excel update time automatically in a given cell within the spreadheet.
I have a spreadsheet that I need Excel to update the time automatically .
I would like Excel to update the time automatically in cell A1.
I have done some research and found the following thread but this only works when we close and open the spreadsheet.....
View 9 Replies
View Related
May 31, 2006
I have a worksheet(A) with rows of data associated to a date that gets a new row of data points once a month. On the second worksheet(B) I have two columns, one (Current Month) to show the data in the newest row (transposed), and one (Previous Month) to show the data in the row above it (from the previous month)(also transposed). Is there any way to get the columns in worksheet B to automatically read the newest row of data from worksheet A into column Current Month and automatically update the column Previous Month with the row above it?
View 7 Replies
View Related
May 3, 2006
I am linking to cells on a spreadsheet and in some cases the formula is showing in the cell and in others the contents of the linked cell. I have forced updating (F9 )and F2 enter with no effect. Is their something i am missing as I want all the links to update automatically. If I copy and paste a working formula into one of these cells it updates albeit with the wrong reference but if i go in and edit F2 etc then it shows as a formula.
View 4 Replies
View Related
Apr 30, 2009
I am trying to find some VBA that will allow protected cells to be updated when a user enters or selects data in other cells.
For example:
Cell 'A1' starts out blank.
Cell 'B1' has a drop down to select specific items.
Cell 'C1' is the date of the order and is a locked cell.
Cell 'D1' is the date of completion and is a locked cell.
The worksheet is protected to prevent direct changes to cells C1 and D1.
If a user enters any information in A1, then C1 displays the current date.
If a user selects 'Complete' from the drop-down list in B1, then D1 displays the current date. Both of these actions are independant of one another. This format is the same for every cell in the 4 columns indicated above. I thought I was able to do this in another spreadsheet I created a year or so ago but I have not been able to figure out what I did and I do not have the spreadsheet to look at.
View 5 Replies
View Related
Feb 22, 2012
Cell C3 has "Joe"
Cell X44 is a VLOOKUP that retrieves "Joe"
Let's say Joe goes on vacation. The workbook user goes in and puts a blue fill in C3. Cell X44 would also need to change automatically.
What's needed to make this happen?
View 1 Replies
View Related
Apr 26, 2013
I am working on a manpower spreadsheet and need for one spreadsheet to extract data from another and automatically update if it is changed and I am struggling below is an example of what is on spreadsheet 1:
Mentor.jpg
and the information from spreadsheet 1 is copied to spreadsheet 2, however if amendments are made to spreadsheet 1 they are automatically updated on spreadsheet 2:
Spreadsheet 2:
C0-ord.jpg
View 1 Replies
View Related
May 25, 2007
I have a custom menu bar. Here is a part of the menu code. The SubMenu Items are various pipelines that am analysing. In a year time the user may add a pipeline. Is there any way to have a code to update this menu bar based on a changed list of ipelines?
Sub SetMenu()
ZapMenu
Set NewMenuBar = CommandBars.Add(MenuBar:=True)
With NewMenuBar
. Name = "QRA"
.Visible = True
End With
' Copy the File menu from Worksheet Menu bar
CommandBars("Worksheet Menu Bar").Visible = False
' Add a new menu
Set NewMenu = NewMenuBar.Controls.Add(Type:=msoControlPopup, Before:= _
2)............................
View 2 Replies
View Related
Mar 12, 2007
but on my sheet the cells wont automatically update with the colors unless I double click the cell then click enter - it then refreshes and inserts the color.
View 9 Replies
View Related
Jul 31, 2008
I have two worksheets...
Sheet 1
A1: description
A2: Target Iteration
A3: Concat A1, A2.
Sheet 2.
A1: Drop down datavalidation list selected from A3, sheet 1.
On sheet 2, a user can select from the list. If a user changes the value in A2, sheet 1, I want the value that is associated and already selected in A1, sheet 2 to automatically update. There is a 1 to many relationship with the concat and the drop down. In that, sheet 2 can have multiple rows with the same value from sheet 1 A3. Is there a way when A3 sheet 1 changes, to search in A:A in sheet two and update the values for those records that match the original value in A3, sheet 1?
View 2 Replies
View Related
May 1, 2013
How to create a dropdown menu to pick from two selections?
Basically, I have a 'Status' column and the status will always be 'Open' or 'Closed' and I'd like you just to be able to click a cell in that column and select one or the other.
View 2 Replies
View Related
May 5, 2014
How can I write my code so that the drop down box always is visible ( like a combobox)? This code is correct and makes a drop-down list but I want it visible at all the time.
[Code] ....
View 10 Replies
View Related
Feb 12, 2013
i looking for a drop down menu ..! like year , month so that no change that area
View 2 Replies
View Related
Dec 23, 2013
I'm looking for a way for excel to output data to a cell dependent on what I choose from a drop down menu.
For example. I have a drop down menu with 3 options. 1,2 and 3. What I want is that if I choose option 2, then in cell A2 (or whatever) would output the value of 2, say "2222". Or if I choose 1, then A2 would output the value of 1, say "12345".
View 6 Replies
View Related
Jul 27, 2014
I have a normal validation dropdown menu/list. (say it is based on the cells B1:B20)
When i use a filter and the results are cell B1,B5 and B8 the dropdown menu still shows cel B1:B20
How can i make it only show cell B1,B5 and B8?
View 1 Replies
View Related
