Make A Cell Look For Another Cell Value Then Call Up A Drop Down
Nov 30, 2007
Is there a way to create a multiple dropdown (Similar to Windows Start menu) so that the user can select the item and its properties then the selections be placed into multiple cells? For example, i select wood from drop down list and i get another drop down list asking for the type of wood, I select MDF and another drop down ask for thickness. when I finished my selections, then the selected Items copy themselves into 3 different cells.
I have a drop down in (A1) cell and I select an item from it. I want (A2) cell to check the name in (A1) then call up another drop down i already made in (A2).
View 10 Replies
ADVERTISEMENT
Sep 25, 2013
I am trying to send my field reps a spreadsheet that will allow them to pick the proper location for each building. The problem I am having is that there are ~45,000 buildings, each with anywhere from 1 - 92 locations. Here is how my spreadsheet is set up.
Sheet 1
Column A has the Buildings THIS IS NOT A DROP DOWN. THIS IS A STATIC CELL PRE FILLED OUT
Column B is where I want the drop down to be available for the rep to pick the location
Sheet 2
Column A has a list of the buildings
Column B has a list of the locations
I understand that normally I would need to create a named range for each building and its locations. However, there are more Buildings than columns in Excel. Is there a way I can do this using Index/Match, or Offset, or Indirect? I have a sample spreadsheet that can be found in my dropbox account using this link [URL]
View 6 Replies
View Related
Feb 14, 2013
Im doing a project and Ive heard that previously, this was done by copying and pasting which took countless man hours to do.
I want to make automated reports of call center data per day per agent. I would like for it to exported into a single excel worksheet with a tab for each Agent, listing the stats per day. What program would be the best to accomplish this feat. I was thinking of importing the information to access to create to muniplulate the information in a one click fashion. but im not sure if i could get the data back to excel.
View 2 Replies
View Related
Mar 19, 2009
I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.
View 2 Replies
View Related
Feb 11, 2010
I want to be able to call the bottom number in a set of data that is ever expanding. I don't really know how else to describe it , so I will give an example.
Say I have:
3
6
4
I would want to be able to call 4, but then if I had:
3
6
4
5
I would want to be able to call 5, and so on. Is there any simple way of doing this? I basically want the maximum cell name, and the corresponding data inside of it.
View 4 Replies
View Related
Nov 3, 2008
I would like a code that will look for a workbook and then look in cell a5 and return number to a45 of active work sheet. I would also need it to add a6 + a7 + a8 and return sum to a46
View 2 Replies
View Related
Jul 15, 2009
I have two cells, both of which have drop down lists for options 'a' & 'b'. When one equals 'a' the other should be restricted into only saying 'b' and vice versa. I would also like the user to be reminded that he can only select 'a' once from the two menus. Ideally I would like to do this in a formula rather than VBA?
View 2 Replies
View Related
Feb 28, 2007
how to create a drop down menu and grab data from the other side. pls have a look for a while at my attachment to check it...has anybody can provide me the steps
View 12 Replies
View Related
Nov 7, 2007
how can i make the drop down box bigger to display my text?
heres my problem
http://img220.imageshack.us/my.php?image=probij1.png
View 14 Replies
View Related
Feb 5, 2014
I am trying to write a macro that will make the bottom cell in a column equal to the top cell. The top cell will not always be in the same row and there won't always be the same number of cells.
View 1 Replies
View Related
Feb 9, 2013
I have a macro that is woking that is activated either via Ctrl-p or by an icon in my quick links.
I would like to call the macro when I enter text in the input cell C7.
At the moment I enter text in C7 and then call the macro to perform a series of tasks.
I would like to make the macro and tasks perform when I enter the text in C7 and hit return or enter key.
Is this possible??????
View 3 Replies
View Related
Oct 23, 2007
I'm trying to create a macro that will check that an Swedish corporate identification number (CIN) is correct. Swedish CIN conist of 10 numbers and are always written 123456-7890. The last number is a control digit to see if the CIN is correct. I've managed to get the macro working but I am not able to get it to work automatically. that is I want the macro to start running immediately after you have entered a companys CIN. In my template you are supposed to enter the CIN in cell A1, and I want the macro to check that immedately when you have pressed "enter". I can not get it to work. the macro works when I do it manually, that is Tools>Macro>Macro..>Run. I've read all about it here but I guess I just don't get it
View 5 Replies
View Related
Sep 26, 2006
how to make a cell a color depending on a number in a different cell? Example...if A2 is 92.6 how would I make D2 blue? But if A2 were 91.9 how would I make D2 red?
View 5 Replies
View Related
Oct 16, 2008
I have a Drop down box on my main sheet with the options "plan 1" "plan 2" "plan 3" etc... these options read from a list i setup on sheet 2 using the data validation list feature.
When i choose one of the plans from the drop down box I want it to populate the fields D13:D20 with data from more defined lists in the 2nd sheet.
View 9 Replies
View Related
Aug 3, 2009
Column A - I want to make drop down boxes #1-30 - which would represent quantity
Column B- That will be 30 rows of dollar amounts
Column C - To be able to calculate the quantity x dollar amount
I'm able to create the drop down boxes with the numbers, but say I choose the number 5 by the dollar amount 200.00 It won't calculate 5 x 200.00....
I've been trying the formula you would use to find an average, and i've tried the if statments, but my drop down box isn't being recognized.
View 9 Replies
View Related
Oct 6, 2009
If I have 12 sheets in a workbook (Jan, Feb,etc..) can I have those names in specific cells (A1,B1,etc..) and call them out in a formula as the cell name as opposed to the actual name?
like A1!C4:C100
instead of Jan!C4:C100
View 2 Replies
View Related
May 16, 2014
I am trying to add a macro to the ACCT DATA sheet, which calls one of two subs (AddCarriertoChecklist() - or - ClrPolChList() located in seperate modules). The macro should call them depending on whether "X" is entered in a cell in column "E". The issue lies in that I have macros doing a few things to this sheet already, and I am unable to tie this one in.
I have the two subs (AddCarriertoChecklist() - or - ClrPolChList()) working. I just can't seem to get them called. This small bit is how I was attempting to call them.
[Code] ......
Below is how I currently have it tied in with the rest of the code for this sheet:
[Code] .....
What is it that I am missing?
View 2 Replies
View Related
Jun 8, 2014
I have a listbox1 which lists items from a rowsource, when i click on an item within the listbox i would like to call the value from another cell and populate into textbox1 on the same sheet1.
View 1 Replies
View Related
Dec 27, 2012
code to do the following:
If any cell in range T75:KH1000 is selected whose value is "Exit", call the macro named View6.
(There are about 40 non-contiguous cells in this range whose value is "Exit".)
View 2 Replies
View Related
Apr 26, 2013
I have some Worksheet_SelectionChange code that automatically calls a Userform when a cell is selected.
What I want to do is retrieve the data from the cell where the Userform is called from and enter it into a textbox on the Userform.
There are 3 other columns to the right of the cell that is selected.
If there is data populated there, I want this to be copied to the appropriate textboxes on the Userform too.
View 1 Replies
View Related
Jun 23, 2014
I trying to create a paperless petty cash system. I have my sheet all setup and calculating how I want. When a user makes an entry they Enter their name in column "W".
I am trying to overcome the problem of accountability. I need to achieve a cell calls for Username and Password and if correct the persons name is entered into cell then Row is locked to prevent figures being altered etc. But also if user made mistake they need to unlock it somehow someway
Sure this achievable from snippets of info I seen online but its way beyond my abilities. I realise a determined user can circumvent this if they wanted to.
View 5 Replies
View Related
Oct 9, 2006
I have a value in a cell named subNo. whatever that value is I want that routine to be called. How do I concatenate Sub & the number?
Sub WhichSub()
Dim varSubNo As Integer
Dim mysub As String
varSubNo = Sheets("Main").Range("subNo").Value
Call Sub & varsubNo 'how do I concatenate this?
End Sub
View 5 Replies
View Related
Jan 2, 2007
I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on).
Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction?
The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.
View 14 Replies
View Related
May 13, 2009
When creating a drop-down list using Validation, is there any way to make the source a different worksheet in the workbook? Right now when I click on Source and select my list, it will not allow me to go to another worksheet.
If I manually enter a reference to cells in another worksheet, such as 'PCP'!$A$2:$A$250 it only shows that cited reference, not the actual list.
View 3 Replies
View Related
Dec 16, 2009
How do you make a Yes No combo box always have the default answer as Yes appearing on a user form but still allow the user to change it to NO?
View 9 Replies
View Related
Sep 7, 2013
In an Excel sheet, in A1 I have written B1 and in A2 I have written D20.
I have a data panel in B1:D20.
I would like to call a vba function my_Fun that acts on my data panel and returns a double in cell A3.
Instead of writing my_Fun(B1:D20) in A3 I would like to be able to write my_Fun(A1:A2), where the entries in A1 and A2 are called, rather than A1 and A2 being used to define the range themselves.
View 5 Replies
View Related
Feb 13, 2013
I have several blocks of data that I have defined under several names to make data processing much easier when writting formulas. They problem that I have right now is that depending on the value of one cell, I need to call up a given defined name block of data to be used on the calculations. These blocks are labeled as DATA400, DATA500, ... user will input information that will allow me to determined what block needs to be used, user will input data like 400, 500, ..., but to be able to call a block of data I need to reference the complete label DATA400. I have tried to concatenate "DATA" to whatever value is input by the user and use the concatenated value to call the specific blocks of information but it doesnt work.
View 8 Replies
View Related
Mar 3, 2007
The master has rows corresponding to numbered files:
4300 | CellValue1 | CellValue2 | etc
4301 | CellValue1 | CellValue2 | etc
In attempting a simple formula (a couple VBA codes I tried did not work and were probably substantially more than I needed anyway), I made the following:
='CMain FolderSub Folder[concatenate(cell w/file number,".xls")]Sheet1'!A1
This is identical to the copy/paste link formula currently in use except that I am trying to have the actual file number/name generated off the master list instead of what is in the file itself.
Purpose: in case I was not clear on this above, I am trying to automatically populate the master worksheet with the data from the workbook. The current procedure is to copy a line of the data from the workbook, then paste as a link in to the master worksheet on the row corresponding to the file number.
View 6 Replies
View Related
Apr 3, 2009
I have several hyperlinks that may or may not contain data, the linked cell will display "0" if there is no data. When I print I dont want the "0"s printing.
How do I make the cell display nothing when a hyperlink cell is nothing?
View 4 Replies
View Related
Oct 30, 2013
I want to make a cell blank if nothing is written in another cell. I have used this formula in C4: =IF(ISNUMBER(C3),IF(C3<180,C3+180,C3-180),"")
View 1 Replies
View Related
