We are working on having the spreadsheet display the correct options, depending on what criteria are chosen. There are three choices in the first criteria and two choices in the second criteria. These choices are presented using data validation so they will always be formatted correctly. Worked on conditional formatting to display results but did not make much progress. Started working on "if" statements to display results, looks like this may not be efficient. Spent a lot of time reading, trying to find a solution.
I am trying to display some text based on another value
This is what i am trying to achieve
Conditional formatting (Refers to range(O3-P6) =U3="A/L" (Then Display A/L in the cell) =U3="SICK" (Then Display SICK in the cell) =U3="OTHER" (Then Display OTHER in the cell)
Is It Possible To Embed Pictures So That When I Do Lookup A Code It Then Shows Me The Picture Of What It Is Im Looking For. Ie If I Was To Type In Kettle It Would Show Me A Picture Of A Kettle In The Next Cell?
I am trying to display result of risk assessment matrix in excel. I have three columns PROBABILITY , IMPACT and RISK RATING (probability *impact).
Probability = Very Low(1), Low(2), Medium (3), High (4), Very High (5) Impact = Low(1), Medium(2), High(3) Risk Rating = Low (value between 1 -3), Medium (value between 4 - 6), High (value between 7 - 15)
Is there any way that I just use TEXT in the cell (visible to user) and excel does its magic in the background using the numbers that I have for each TEXT? I don't want to display numbers.
I have some dynamic named ranges in sheet1, and in sheet2 I have data validation dropdown list which has the names of all the DNR's in it.
What I want it to do (in sheet3, no less) is for the user to be able to pick a named range from the dropdown list, and have a particular column in sheet3 then display that entire named range.
I have made a 'data' worksheet which is the source for the data validation in sheet2. Each item in the list identically matches the name of each of the named ranges. I was hoping to be able to use some form of =INDIRECT but alas, no such luck.
So it's almost like a copy and paste function I'm after, where:
If you pick "Schedule_From" out of the DD-list, then DNR 'Schedule_From' is what is pasted in Column B in Sheet3.
I have numbers that will display in column G. I have payment types entered in column E. So if 'C FUEL','FA','C M/C', is entered in column E I want the number in column G to be red.
I am trying to do in the title so here it goes. I want a user to be able (on form 1) to enter a list of codes that refer to specific requirements (e.g. code PB114 may mean the user needs to perform a pressure test) and then excel will automatically display the requirement somewhere below. It is going to be somewhat of a database. In otherwords lets say in cell A1 you type in a code, e.g. PB114. In a range of merged cells or somewhere below that cell I want the information "Perform a pressure test" to appear.
I have a tab set up to display information that has been colletect on other tabs. What I would like to do is change this information depending on what month is selected.
For example, if I select December then data would be pulled from other tabs and displayed. If I Select June the information would change and select other data from the same tabs.
II have a list of football fixtures (see attached sheet - barclays premiership) each with a different status Win,Loss,Draw,Pending. I want to display the next team with a Pending status in a cell at the top of the list (cell T13/14) so the user knows at a glance what the next fixture is. I also want to display the days remaining to that fixture in the cells below this (cell T15/17).
I wonder if the following is possible in the worksheet_open event. I want to be able to open my worksheet and see via a message box all the important features I need to look at.
Using column AG, Take the cells that are conditionally formatted to red, take the corresponding cells in column A & B and output this information in a message box.
I want a table to display data based on which month i select from a drop-down list, the data is of course extracted from a different table. For example, in my final table( highlighted in yellow), i want to display the revenues, cost of goods sold..etc of April in this table when i choose April from the drop-down list, the data of the entire year is located in another table that i plan to hide, as we only need to review one month.
I am trying to create a formula which will allow me to type a word in a cell on the Main sheet, and then pull any row from multiple sheets and display them on the Main sheet. For example, my sheet named Main looks like this:
A B C D E 1 Query: 2 Fruit Store Cost Mode Date
And there's a sheet for each month with the same format and different data: A B C D E 1 Fruit Store Cost Mode Date 2 Apple Dominicks 1.99 Bagged 3/16/2014 3 Apple Piggly Wiggly 2.19 Ala Carte 3/14/2014 4 Banana Jewel 0.49 Bagged 3/1/2014 5 Banana Dominicks 0.57 Ala Carte 3/16/2014 6 Banana Costco 0.69 Ala Carte 3/16/2014 7 Cantaloupe Jewel 2.99 Ala Carte 3/14/2014 8 Cantaloupe Dominicks 1.99 Ala Carte 3/1/2014 9 Eggplant Jewel 0.99 Ala Carte 3/30/2014 10 Eggplant Dominicks 1.19 Ala Carte 3/30/2014 11 Eggplant Costco 1.29 Ala Carte 3/21/2014 12 Eggplant Safeway 0.79 Ala Carte 3/16/2014 13 Pears Jewel 1.19 Ala Carte 3/14/2014 14 Pears Dominicks 1.59 Bagged 3/1/2014 15 Pears Piggly Wiggly 0.99 Ala Carte 3/30/2014 16 Rhubarb Jewel 0.99 Ala Carte 3/14/2014 17 Rhubarb Piggly Wiggly 0.59 Ala Carte 3/14/2014 18 Rhubarb Costco 0.89 Ala Carte 3/14/2014 19 Tomatoes Jewel 1.99 Ala Carte 3/1/2014 20 Tomatoes Safeway 1.69 Bagged 3/30/2014 21 Tomatoes Dominicks 1.89 Carton 3/27/2014
... and so on. On my main sheet in Cell B1, I want to type a fruit name, such as Banana, and have every row in every sheet with Banana in column A,pulled and displayed on the Main sheet. Firstly, is this even possible with a macro?
I am trying to auto-populate text in cells in area A, based on data I enter into other cells in area B. I want the area A cells to be for display only, as all editing will be done in area B. The problem is: how do I do this such that the text I write does not get cut off if is longer than the column width? See the attached document for a clear example and description of what I am trying to do...
I have a column of locations where all the locations start with 'SHIP TO - ' followed my the actual location which can be of varying lengths. How can I display everything after the 'SHIP TO - ' in an adjacent column. My instinct is to use a RIGHT Function, but I don't know how to get that to only display the variable length text after the 'SHIP TO - ', e.g. in another column I want this
SHIP TO - ABC COMPANY SHIP TO - A VERY LONG LOCATION SHIP TO - HERE
I have a cell with a %. I want to return text in another cell based on that data i.e. between 90 - 100 = excellent, 75 - 90 = good, or something like that.
one of my suppliers can only provide me with a basic .xls product list as shown in the attached test sheet.xlsx.
Is it possible to create and run a macro from test sheet.xlsm that will extract data from test sheet.xlsx, specifically from below the heading on row 64 down to and above the heading on row 123 and paste into the (new) worksheet in test sheet.xlsm
This sheet is updated daily and all the heading rows are constantly fluctuating as products are sold and added.
I can do this manually easy enough but if there's any way that this can be automated
What type of formula would resize a text box based on the input of two cells? Here's what I'm trying to accomplish:
A1 - width (in inches) A2 - height (in inches)
Converts the text box to that height & width.
This is for a sign request form I am creating that would give our requestors the ability to see the size layout of their sign and then input their text to match what they're looking for.
Sheet 1 will act as a summary for sheet 2, showing only the last 5 entries from sheet 2.
Sheet 2 is based on football results of a season which will have a total of 34 league games plus cup games.
Sheet 2 has 4 columns:
Game Number Home Team Result Away Team 1 United 2-0 City 2 Sportive 4-2 Uniao 3 Real 1-0 Ateltico 4 Villa 1-3 City 5 United 2-1 Real 6 Atletico 0-0 Villa
So sheet 1 will show the last 5 results as the season progress's and new data is added.
I have been able to extract column 'GAME NUMBER' using the following formula:
=INDEX('Back end 1'!A:A,MATCH(9.99999999999999E+307,'Back end 1'!A:A)-ROWS('Back end 1'!A2:A$6)+1)
I am struggling to find a way to pull the last 5 data that is text based.
I have a worksheet that has 20 quotes in cells A1:A20. Is it possible to have a userform display a different quote in a text box each time the form is activated?
I am quite inexperienced with Excel and I am struggling to understand how should I set up a formula, within the data validation function to achieve the following:
I need to restrict a certain set of cells, for people to be able to input only the following values: "1", "0.5", "A", "H", "0.5A" (or 0.5a), "0.5H" (or 0.5h)
And I would need the data validation tool not to include blank cells.
I'm trying to find vehicle make and model in a cell containing a lot of text and then display that in the formula cell. For example if A1 is a paragraph that contains somewhere within it "Ford" & "Ranger". I want B1 to display "Ford" and C1 to display "Ranger". I have a list of vehicles makes (column A) and models (column B) on a seperate sheet.
I am trying to hide/display text by using form fields. I swiped the idea from a spreadsheet I obtained from a vendor and thought I would extend it to suit my purpose.
When I check the box for "table one", I'd like for the data that I have associated with it to display. When I uncheck the box, I would like for that data to be hidden. The goal is to be able to choose one data source and see at a glance which fields come from that source and what their names are. The formulas that currently exist for the cells in column I do a nice job of putting text in a field when the box is checked, but I don't want to have to rewrite the formula in the cell if/when the source of the data changes. It's a lot of long schema/table/field names. Maybe that's the only way, though...
I scrubbed and mocked up column J to try to demonstrate. It's sorta color coded.
And it might be that using form fields is not the best way to hide/display text based on source type.
I need a little help with the same employee time sheet that I am working on in Excel 2007. I have a dropdown box in Cell E1 that lets the employee select their name. Example, if the choices in the drop down are: Smith, John Jones, Paul Nelson, Bob and Hall, Bill. So the names are Last Name, First Name. Once the employee chooses their name, I would like Cell G1 to display "Hello (E1). Welcome to AA Company." (where E1 is the employee's name but First Name Last Name - so it is reverse order of the choices in the dropdown). If E1 is left blank, I would like Cell G1 to display "Hello. Welcome to AA Company."
Second Problem:
How can I get rid of #VALUE! in a cell without messing up the formula of that cell or the cell it corresponds to??
When I enter a url in a cell it shows up underlined and with a different color (blue). I tried formatting as general or text to no avail. I deleted and reentered without http etc. but it still is underlined and blue. Anthing I type in that cell now is underlined and blue. If I click on the cell it launches my browser. I just want the text of the url in the cell.
How about if I have a long string of numbers that I want to display in another worksheet. For example, here is an item id off eBay, that I want displayed in another worksheet if it is present, otherwise, it should be blank. Here is the item id, they are all unique by the way.... 230092645222. I tried to use this formula below but it didn't work.
