Display Full Contents Of Lengthy Cell Upon Selection?
Jul 3, 2013
I am working with a catering form that someone else created at work. It has a drop down list of menu items available. Once an item is chosen, the item description pops up.
These descriptions are so much longer than anything else in the row (item name, qty, #, cost). Is there an option to make the full text temporarily visible by selecting the cell, and leave it cut off the rest of the time? I am trying to keep the form at one page.
If I have a pick list, or drop-down list, in cell B21 and one of the options in that list is "Clear", how can I get the contents of cell C21 to be cleared when I select the "Clear" option in B21?
Constraint... Don't want to use VBA.
I am thinking of hiding a formula somewhere other than in C21 that evaluates B21 and does an If Then kind of deal to clear C21.
I'm looking for a formula that will display the contents of a cell location. In other words, I have a sortable list (example: A3 - C20, where column C cells contain either: "EEE", "FFF", OR "GGG"). If I sort by "FFF", it will only display rows with that criteria. I need a formula to place in C1 (above the list), that will display the contents of the top cell in column C of my list, reguardless of how it is sorted.
I have a field set up to display the contents of a cell (sheet 1) using VLOOKUP if a match is found in a separate worksheet (sheet 4). Here is the code I'm using:
=VLOOKUP(C:C,Sheet4!G:G,1,FALSE)
Is there a way, if there is a match, to display the contents of another cell of sheet 4 in the cell of sheet 1?
I have found Displaying an image based on text contained within a cell. which appears to be a very similar question, but no steps to follow.
Basically I have a folder with around 300 images in it, each is called ProductId number.jpg eg Z99S1234567.jpg
In my sheet I am using the same ProductId number and would like to display the product image on the sheet. I have A1:D19 as spare space Lookig at the info I have found the image will have to go into a cell, so can I break all the rules and merge cells to fit the image in, or do I need to make a single cell big enough or can I use VBA to import the image somehow to a specific place on the sheet.
There will only ever be one looked up image on the screen at a time.
I have data arranged in cells A1 to Z1 as Name1, Amount1, Name2, Amount2, Name3, Amount3, etc. Is there a formula that can determine the name that corresponds to the maximum amount in the row?
I want to display the contents of cell B5 in A7 by using cell C7 to show the location of the cell to be displayed. Cell C7 has a formula that shows the cell location of information (text) that needs to be displayed. How can I show in A7 the contents of cell reference shown in C7? In figure attached I show an example to better understand. Want in A7 to show the contents of B5 by reading what is in C7. So A7 cell should show word Road.
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.
Can anyone tell me if its possible to input some ones initials into a cell and when you hit enter, their full name is displayed instead of the initials:
ie input FB and the same cell displays Fred Bloggs?
I have two columns, column Q and R. Column Q has Data Validation set, where you can only choose one of four options in any given cell between rows 2-250,000. When "Complete" is chosen, the cell turns green. Now when "Complete" is chosen in column Q, I need the cell next to it in Column R to auto-fill today's date. However, the date should not update to the next day. So if the cell autofills to today's date, which is 12/6/13, tomorrow, when the date changes to 12/7/13, the cell still reads 12/6/13.
I have a worksheet with a lot of different conditions applied to a lot of cells. I'd like to do some housekeeping, but to do that, I would like a clear and complete list of all cells that have conditional formats attached to them, and what the formula/criteria is for applying said format. I don't even care what the formatting is, but that would be nice too.
So, when I go to my "Conditional Formatting" screen, I get something like:
Now, this doesn't show me much of anything about what the formula actually is. I need to select it and look around. I'd rather just get a full listing of what the rule says...
And where I might have the same rule applied to different ranges of cells And so on.
Is there a more efficient method to what i have attached? i.e. if E4=anything between B2 and B10 then C2 is displayed. Between B11 and B16 then C11 is displayed.
I'm playing along with Excel. I discovered it doesn't like cutting and pasting in VBA. This screws up formulas in cells.
It much prefers copying and pasting. So this involves an extra step, going back to the cells you just copied and clearing them.
So I have a selection of cells and I just copied them to a different location. Naturally the location I just copied it to then becomes selected.
I would like to go back to the cells that have the dotted selection around them and clear them. If I simply use Selection.ClearContents it will clear the currently selected cells, NOT the dotted selection.
Command to clear the contents of the dotted selection?
I'm researching a load of financial data downloaded for me from Bloomberg. It lists daily prices of 15 commodities for nearly 20 years in some cases! Its far too much data to get anything worthwhile out of, so I'd like to know if any of you guys have used or know what the VBA is to write a macro that will reduce all the data from daily to monthly. (ie. I want a macro that will allow me to quickly delete all data corresponding to dates which are NOT the end of the month).
What I would like to do is use the IF function to retrieve data from another sheet called Data which has six columns but has various amounts of data that I would also like to pick as a drop-down menu.
The initial cell has a dropdown populated with data using the Data Validation.
Example would be if the following is selected from the initial drop-down menu and then allows me to select data depending on the previous selection.
PX1 - fetch information from Data T2 to T25 and then select that data which then would allow me to select data again from say column U2 to U9.
I am trying to find something that would allow me to have a spreadsheet clear the contents of a certain cell based on the selection made from a data validation list which resides on the same row. This can best be described with an example.
The user selects anything but " " or "none" from the validation list, which for this example resides in C5, would trigger code to clear the contents, if any, in AA5. If " " or "none" is chosen the value remains.
This capability should be available for each row through 100.
I searched but didn't find exactly what I needed. I have a workbook with 31 sheets. It is a price guide with each category on a separate worksheet. I figured out how to list the sheets on a separate tab. What my client wants is the ability to:
1. select certain categories for printing, the ToC, Cover and backcover pages have to print in every case
2. the ToC has to change depending on the sheets selected.
I'd rather write some code and give him an an easy command button rather then teaching him how to select non-concurrent sheets and printing only active sheets.
What I'm really stuck on is the updating of the ToC with active sheets only (category and starting page which changes depending on pages selected).
I would like to be able to display all of the sheets in a workbook as a list on the front sheet.
I have a front "Contents" Sheet (attached at the bottom of my post)
In the "Ticket No." column I wanted to have the sheet name, in the "Date" and "Description" column I wanted to display cell values from each sheet; which would be the date and description of that sheet/"Ticket". The "Resolved?" column I will be able to do after I have this part figured out.
I have created a User Form that has been tested and is working properly. Now my last step is to do the following:
I would like to Display the User Form (coded as CommRM) if in Column C (can be any cell as it is a large worksheet) someone selects "Retail News" from the drop down option.
The code that I have been able to create so far is below. The problem is that when I select Retail News from a drop down in Column C the user form does not appear.
VB:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range (C14, C3333).Text = "Retail News" Then Call UserForm_Initialize End Sub Private Sub UserForm_Initialize() Load CommRM CommRM.Show End Sub
I'm wondering how I could display information based on the user input through dropdown selection. I know how to make a dropdown-list already.
Example: A1 has a dropdownlist with Apple and Banana in it. If I select banana then I want B1 to display "8" and if I select Banana I want B1 to display "4".
I just want to create a combo box that will allow my manager --- not so good at using menu commands or the scenario manager --- to choose one of five different budget scenarios. I can't seem to get the actual scenarios to change when the selection is made from the combo-box.
I am trying to display a formatted formula (combination of greek characters, superscripts, subscripts, bold, italics, etc...) based on a selected input. I have a selection cell with a drop down offering the choice of 4 difference scenarios. I want to display the resulting formatted formula depending on which scenario is selected (the formula is difference depending on the selection, as well as perform the calculation.
The calculation works fine, but I cannot figure out how to show the formatted formula. The selection works using IF statements, or VLOOKUP, but does not bring the formatting across. How can I do this?
