Having Cells Filled Automatically When Selecting Options In Lists
Apr 20, 2009
I've been breaking my head over this and i haven't managed to make this work. The attached excel file contains a list of students that participated in exchange programs on the past. What i want this to do is that when i choose the university the student went on exchange with, that the city and country cell fill in automatiocally with their respectuve info. I have a worksheet on excel that has the university name, on the next cell the city, and on the next cell the country.
View 3 Replies
ADVERTISEMENT
Nov 2, 2013
When I click on a cell, for example T13, cell U13 will also automatically be selected. I have looked everywhere for something that is making it do that, but can't find an answer.
It doesn't happen with every cell. I have to do some more clicking around to see if there is a pattern.
View 1 Replies
View Related
Jul 21, 2006
I have dropdown lists in a form and i want to make it so that the user can not input a value other than the ones in the list, how can i do this?
View 7 Replies
View Related
Jul 29, 2008
I'm new to Excel 2007... whilst I'm managing to find most things I'm used to using in 2003, I have an issue in one workbook that I can't figure out.
When I click in some single cells (not all), that cell and several below it automatically highlight as a range... left-clicking initially highlights the cell, but as you release the mouse button, the others below it also highlight.
View 14 Replies
View Related
Oct 1, 2009
I use Excel mainly for creating & updating simple logs, and the problem I keep running into is that when I click in a cell, it will automically select & highlight multiple cells below the one I am trying to work in. It will select anywhere from 4-5 cells up to 13. I don't know what this function is, and I don't know how to fix it. But it makes it very difficult to navigate and cut/paste or change a formula.
View 5 Replies
View Related
Jun 2, 2014
I'm trying to build a invoice template for my business. Trying to make it as simple to use as possible for my staff to input the data. Currently they will manually type in everything but later on I would like to make the spreadsheet have available drop down boxes for the equipment and it will auto fill the hourly rate in.
Right now my main issue is I have the invoice template the way I would like it, but there are only 5 rows in each category. I would like for it to, once the last row in each category is filled, make a new blank row with the exact formatting of the one above it. Then continue to make blank rows if that subsequent row is filled in as well.
Basically, to better describe what I'm looking for, say I have 15 employees on the job and 10 pieces of equipment. I currently only have 5 rows in each category and would like them to expand out automatically without doing a copy rowinsert. It doesn't matter if the page expands to multiple printable pages as long as it doesn't get jarbled in the process.
I am very new to Excel and not even sure if this is possible. I would also need this to carry on with the .xlsm file so that my other employees can use this invoice template on their laptops.
I attached the invoice template I created so what I'm describing can be better understood.
View 3 Replies
View Related
Jan 15, 2009
Is there any way to a column be filled automatically by what is written on others columns.
Example: If one of the cells A2 or B2 and C2 are Nonblank, fills automatically the cell H2 with "ABC2" And If some of the cells D2 and E2 are Nonblank fills the cell H2 with "DE2"
View 2 Replies
View Related
Apr 4, 2012
I want to fill some data to be filled automatically but i am not getting the formula. here is what i want...
When i write customaer name in sold field (b3) all the entry should automatically be filled (g3 h3 i3 j3)in his credit account from (a3 c3 d3 e3).
Somehow i managed to get it work(for one field only) but there is a problem in my formula
Here is my formula =INDEX(A3,MATCH($L$1,B3,0),0)
Note:- l is where i wrote customer name in leaves blank spaces when other customer name comes
View 9 Replies
View Related
Jul 4, 2014
I have two worksheets. In the first one column holds the names of universities, and the next column holds employee names. For example:
London Metropolitan University | Chris Davis
London Metropolitan University | Sean Joesbury
London Metropolitan University | Stefano Carlino
London South Bank University | Simon Forsbrook
London South Bank University | Peter Lacko
University College London | Ben Burch
University College London | Oli Lan
In the second sheet, I'd like the universities to appear as headers to the columns, with all the employees of that uni to be listed underneath. I'd also like for these lists to be updated automatically as new rows are entered in the first sheet.
View 3 Replies
View Related
Jul 18, 2006
Is there a way to set up a conditional format for several cells so that the cells are filled in with red until the user enters text in those cells??
View 5 Replies
View Related
May 21, 2008
Is there a way to set up a cell so that when you click the cell, the cells value is automatically copied to the clipboard?
Example:
A1 = 1
A2 = 2
A3 = SUM(A1:A2)
Can you set up cell A3 so that when you pick it with your mouse, 3 is copied to the clipboard ready for you to paste elsewhere?
I have tried searching through the forum to find an answer but nothing has come up.
View 9 Replies
View Related
Dec 4, 2008
I want to know how to link te two lists in my register so that when i select a particular route in one column the corresponding column automatically selects the transit time from the reference list.
View 2 Replies
View Related
Mar 17, 2007
I have two seperate lists. One on Sheet 1 and One on sheet 2. What I need to do is take the list on sheet 2 and compare it to the list on sheet 1. If any of the items appear on sheet one, I need to delete those items form sheet 2.
So in the end the only items left on sheet 2 will be items that dont match any items on sheet 1
View 9 Replies
View Related
Mar 29, 2014
I have a spreadsheet with 6 hidden columns (B to G). Rows 1 to 14 are frozen and have data that comes from another work book and these rows will be protected. The user will enter data from H14 to U14 and then H15 to U15 for the next row and so on down the sheet. The number of rows of data over a week is variable, a minimum of 21 rows (3 per day) but no maximum.
When the user starts entering new data in the column range H to U I would like to automatically populate the 6 hidden cells on that row with information from particular cells in protected rows 1 to 14. For example B14 would populate with the value from I4, C14 would populate with the value from I5, D14 from I6, E14 from I7 and so on whenever someone enters a value anywhere from H14 through to U14.
I can understand that a worksheet change event would be useful to do this but I guess then it wouldn't want to run every time each cell is populated so I think if it had to activate on a single cell change then the cell in column L would be best. Also, as I understand it, there can be only one block of code per sheet that operates on a worksheet change event, have I got that right? If that is the case then I assume all the code to populate the hidden cells on each row will need to be in this block of code.
View 8 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
Dec 2, 2007
I have a spreadsheet that is emailed to someone to fill in. They then fill in some information and send it on to someone else.
Sometimes they don't fill in all the information so is it possible to have excel check that cells are filled in and to prevent someone from saving unless this is so? Or maybe a message stating that the cells need to be completed if Excel is being closed or saved?
View 11 Replies
View Related
Mar 30, 2008
how do i create a formula or macro that will: Clear the contents of Cell C1 If Both Cell A1 And B1 Are Filled. I will need to check all the cells in column A,B and C.
View 2 Replies
View Related
Feb 24, 2007
I've got a software test plan that has test cases w/ individual pull-downs to select result states (All individually color-coded thanks to a macro). If any state is selected other than "Pass" or "Untested", a text entry feild appears two rows beneath the test case for additional notes and information regarding what behavior occurred when the test was done.
I need a way to a.) Automatically select this text field once any state other than "Pass" or "Untested" is selected in the pull-down, and b.) Require text entry in the field before the user can proceed to the next test case. (ideally w/ accompanying custom error message describing what information is required.)
I've pasted my macro code below: ...
View 9 Replies
View Related
Nov 1, 2013
I have a table with a list of names of some products and their substances, firm, package and price.What I need to do is this. When I type a certain name in another sheet, I want it to show me a cell with the substances, a cell with the firm (that are fixed and cannot change them) and then in the next cell to give me options (if I type "package 1kg" to show me the price of this package, if I type "package 0,5kg" the price of this one, etc.).
View 6 Replies
View Related
Jun 5, 2014
Coding that it does the cells that have a color attached to it only and not the cells that are clear. Right now it is doing the clear cells only.
[Code] .....
View 5 Replies
View Related
Dec 31, 2013
How to sum cells filled with colour?
When I use the colorfunction it works, but I have changed the cells to have different color based on conditional formatting, and now the colorfunction isn't reading the fill color.
View 3 Replies
View Related
Mar 6, 2008
I have a little problem counting filled(numbers,chars, etc) cells i used |:
subtotal with filters , nothing
i used COUNTA, nothing
i used COUNTIF(range,"*"), nothing
is still counting the blanks
View 9 Replies
View Related
Mar 6, 2014
I'd like a code to automatically delete the value in column AK and its corespondent in AL, if the value in AK is filled in column C
View 7 Replies
View Related
May 1, 2008
This thing drives me crazy for the past few days. Please helpI can go to sleep.
I have several columns with numerical data. When certain criteria are met, a person manually makes some of the column fields a green fill color via the color fill button.
Let's say I have data in cells E4 to E14
Below, I have a total field (auto Sum function used to total all),
And, another row with The Colored Green totals.
How do I enter the appropriate code to total only the fields that are green?
I have found some info on verious sites but I have been unsuccesful to implement.
[url]
I attach a sample sheet, I was playing around a bit, you can ignore the fill color red, just deal with the green fields.
View 10 Replies
View Related
Feb 27, 2009
write this in VBA on the Workbook Level, "ThisWorkbook" : IF range (B20:B53, E20:E53, H20:H51) are all filled through user keypunched values--checks and coupon amounts.AND range (C20:C52, F20:F52, I20:I50) are equal to = " "
-- these ranges contain formula that spits out values only when there are discrepancies with the manually keypunched values above' otherwise it's equal to " ".THEN call batch02. batch02 is a macro that prints the specified batch.I have attached the filed I am working with. There are 25 batches, hopefully I can replicate the codes by just changing the ranges and the print macro.
View 4 Replies
View Related
Apr 16, 2009
I want to calculate how many cells are filled with color, how can
View 3 Replies
View Related
Feb 20, 2012
I'm looking for a way to ensure that users of a spreadsheet have filled in all required cells. VBA code which will prompt if a cell is blank which will activate on a button click
All cells are 'Named ranges' so hoping there's a way in which I can point to all named ranges and if they're blank display the below error message.
"Please ensure you have filled in all required fields"
View 1 Replies
View Related
Mar 25, 2014
I want to copy only the filled cells of a column from Range N20 to N1000 and have the following code but this code copy even the blank cells. All the cells Range N20 to N1010 have formula and dependent on the value of another cell and if another cell is blank than cell in Column N is also blank.
Please suggest the changes in the following code so that only filled cells are copied.
Code:
Dim LstRw As Long, sSaveAsFilePath As String, ws As Worksheet
Application.ScreenUpdating = False
With Sheets("Sheet1")
LstRw = .Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row
.Range("N20:N" & LstRw).Copy
End With
View 3 Replies
View Related
Jul 2, 2005
Here's what I want to do:
I want either a combo or list box in cell "A2" to list one of several selections full names, i.e., "Compact Disc, Cassette, etc." When you select the full name it returns it's abbreviation, i.e. "CD, CAS, etc." in the same cell "A2," and also returns it's catalog number in B2 and the label in C2.
In this example CD and CAS are obviously short for Compact Disc and Cassette, but not all the codes are that obvious, which is why I require the translation.
I have a second worksheet titled "data" with an array of data that's particular to a given selection. The list of selections run down a column while the selections data runs across the rows.
View 9 Replies
View Related
May 16, 2007
That is, if I have a range A1:B1 where some cells contain numbers and others are blank, and I want to add just the cells directly to the right of the filled ones, can SUMIF
View 9 Replies
View Related
