Let's say I have a summary table on Sheet 1 6000 rows of data on sheet 2.
In Sheet 2 I have 3 columns, Name, Month and Score. Name Column (A) has names of students Month Column (B) has months January, February and so on. Score Column (C) has data from Green, Yellow and Red. Red is if they failed.
In the summary table on Sheet 1, I need to show all the names that got a "Red" Score. And their corresponding months.
It should look like this.
Month l Name l Score ----------------------------------------- January l Mike J l Red ----------------------------------------- March l Joe M l Red
I have a data validation list where more than one value should show the same list. Instead of make multiple range, I want to make it so if any of the values are in a cell the data validation list will show the list that goes with those values.
I currently have a drop down menu in one of my worksheets, in which I have several different text values entered. What I would like to do is link each of those text values to a numerical value, which would be entered in to another cell. So if I select "Option A" from my drop down list, and Option A is equal to 200, I want "200" to show up in another cell. If I select "Option B" from my drop down list, and Option B is equal to 400, I want "400 to show up in that same other cell.
I have 2 different formulas that I need changed in a similar way.
The first formula is for cell AV11: =SUM(BI11,BP11,BW11,CD11,CK11,CR11,CY11,DF11,DM11,DT11,EA11)+10
Every cell starts off blank.
What I need is for cell AV11 to always start off blank until data is entered into one of the other cells. The problem is that since the sum always needs to be +10 only when data is entered in the other cells, I don't know how to keep 10 from showing in cell AV11 when no data is typed in the other cells.
The other formula is for cell CO39: =(CU8)+3
I pretty much need the same thing. If no data is entered in cell CU8, then I do not want cell CO39 to show the 3.
I have the following situation: I have some values in column A. other values in column B. I want to be able to display a list using the values in column A and values in column B. A1-> B1, etc.. Attach file: Book2.xlsx
I have a Workbook with a dropdownlist on it. The dropdown list has some names on it each name will be a refference to another sheet, ie when name Collins Jim is clicked on the drop down list the Jim Collins sheet will appear. I have attached a sample sheet to show you waht i mean.
when i open a xls, i would like to Display the Vertical Menu Of Worksheets (at the bottom left of the tab names)
--this worksheet has many sheets and i find this an easy way to navigate...
(also, how can i write a macro--for a user shortcut--to display this--currently, i hover my mouse pointer over the bottom left tab navigation object and right click to bring up the vertical display of sheet names...)
I have a list with many duplicate names in it, from which I only wanted 1 instance of each name, to be placed in another sheet. So, I recorded a macro that selects, from the sheet called "Data", column E (the column with the relevant list), copy/paste's it into sheet 3 in column A, selects the new column, and runs an Advanced Filter command on it, to identify and display all the unique names in it in the same place. It ran just fine when I recorded it. But then, when I deleted the data created by the macro and tried to re-run it, I got random data. I found that whenever I click on a different cell, it provides a different output. I only want it to select Column E, and copy paste that, not other random columns depending on which cell is currently selected. This is my
Sub Fetch_Unique_Names() Sheets("Data").Select ActiveCell.Range("A1").Select ActiveCell.Range("E1:E2200").Select Selection.Copy Sheets("Sheet1").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.Range("A1:A2176").AdvancedFilter Action:=xlFilterInPlace, Unique _ :=True End Sub
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.
I have a spreadsheet which shows information based on what a person has picked and how long it took them to pick.
What I now want to show is an extract which will show - in a separate area - what shift & person still has not completed the pick (completed time section remains blank) together with the type of product they are picking plus the 'operation number'.
My current spreadsheet is as follows;
[IMG]C:Documents and Settingschristine.lawsonDesktop[/IMG]
Table shows as follows:
SHIFT PRODUCT TYPE MSN OP NBR PICKER NAME DATE PICKED START TIME COMPLETED TIME OVERALL TIME TAKEN AVG LINES PER HR
BLUE T&F 4 001 FRED 6/11/12 17:55 18:40 00:45:00 4
As you will see from the attached picture/table there are 2 lines which do not have 'completed' times shown. It is lines, such as these that I need to be able to show in a separate area.
Im currently creating a spreadsheet for my work, with common problems and solutions to one of our websites.
When the spreadsheet is opened, the user will click a button depending on what sort of problem he/she is having. In the example attached, if the user clicks on "make payments" a form will appear. This will have a list of problems.
if the user choses problem 1 from the drop down list, then I would like the list of solutions to problem 1(from the MPData sheet) to show in the box below. The same goes for problem 2, problem 3 etc.
I have a list of 9 values ranging from 1 to 9 generated by formulas in column A. they can only be "1,2,3,4,5,6,7,8, or 9" and can be repetitive. Is there a formula i can use (not macro please) that will show me what values are missing from the list?
A B 1 4 5 1 2 1 8 7 1
*Note there are 9 values in column A in any order. In this scenario the answer i would like shown is "3,6,9".
I have some data validation drop down lists in excel, I can tab through all the lists but I have to press alt + down arrow to show the list, Is their a way it can be automatically shown as soon as I focus on the tab.
How do i make a drop down list in a cell show Select One in the cell when the cells previous contence (Option selected from drop down list) have been deleted. E.g Cell E5:E400 must show Select One in the cell and when clicked on show drop down list I dont want a input message box or error box i can do that with validation
The list columns 5,7 and 9 has number entries.The userform has 3textboxes.is it possible to link total amount of this numbers result into the textboxes.Like column 5"CZ" entries total will showup in textbox10,column 9"DD" = textbox14
Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) Dim a, i As Long, ii As Long, b(), n As Long ListBox6.Clear With TextBox2 If .Text = "" Then Exit Sub If WorksheetFunction.CountIf(Range("cv:cv"), .Text) = 0 Then MsgBox "No Entry !" TextBox2 = ("") Exit Sub..........
This link worked perfect for my needs: Create a List of Hyperlinked Files: But is there any easy way to only show the filename insted of the full path for the name of the hyperlink? Now it shows it like :C:MyDocumentsTestings est1.xls I only want it to show as: test1. I still want the hyperlink to work
Is is possible to get a dropdown list to show the actual characters as they appear in windings or marlett as shown in the source? When I try I am just getting a load of u's with accents and dots above.
I have created a drop down list but notice that the button (the arrow in the square) does not show up unless I click on the cell. Is there a way to show the button at all times so the user knows a drop down list is available?