Linking Pictures To Dropdown Name Range?
Jul 16, 2012
I've created a name range and i'm now trying to link this to a series of pics
For example
Sheet 1 I have in A1 the drop down box (to be about 50 long)
Sheet 2 I have all pictures named as per the list in sheet 1 e.g
Named dropdown list
Apple
Banana
Pear
Corresponding pictures named
Apple
Banana
Pear
What I am trying to achieve is when "apple" is picked from the dropdown list that the "apple appears say in C1 on sheet 1
PS. Forumula based such as IF or Index etc ican't use VBA or macros yet !!!!!
View 7 Replies
ADVERTISEMENT
Mar 2, 2008
ive done some data validation and created a drop down list but what im trying to do is
once i have selected what i want from the drop down list i would like a picture to appear next to it automatically
ie
if i select kettle it will show a pic of a kettle
View 14 Replies
View Related
Dec 5, 2013
I'm trying to work out how to allow a formula to be changed by pointing part of the code at a drop down list containing worksheet tab names from another workbook.
View 2 Replies
View Related
Oct 19, 2012
I need to link this summary sheet projects to this plant and equipment list sheet to show each project numbers separate weekly cost hire on the summary sheet.
View 3 Replies
View Related
Jan 21, 2013
I have two identical drop down lists (months i.e. Jan, Feb, Mar ...) in two different sheets but in the same workbook. Is there any way where the user changes the month in sheet 1 & the other drop down list in sheet 2 changes automatically to the same month selected by the user in the sheet 1 or vice-versa?
View 1 Replies
View Related
Aug 21, 2013
I have an array of data that I want to be able to filter based on the selection in a dropdown box. For instance, If I select district manager, I want to show the data of only the people who are successors for district manager. For my own reasons I want to use this method rather than just applying the standard filters to the column headings.
I have attached a sample workbook : DummyData.xlsx
View 5 Replies
View Related
May 15, 2014
I got the attached dashboard example from a source online.
I was wondering how they linked their pivot chart with a drop down (data validation). This is the pivot chart on the bottom right that is labeled "Brick Styles".
Dashboard_Your_Scorecard_Complete_2010-1.xlsx
View 1 Replies
View Related
Feb 16, 2014
I've had a search on here, but can't quite find what i'm looking for. I have a cover sheet with a drop down list which has customers in it. under it I have the customers address, phone etc. What I am trying to do is when I click on a particular customer, I want the address and phone numbers to all fill in automatically. I have tried a few things, but to no avail.
View 12 Replies
View Related
Dec 3, 2013
I am trying to attempt to create a payroll spreadsheet with certain aspects and with multiple worksheets. so what im trying to accomplish is this
1/ on my main worksheet would have the payroll template there would be 2 columns (1) would be "routes" (2) would be the dollar value of that route.
2/ i want to be able to pick from a drop down list in colume (1) which will have various routes such as A,
B, C, D, E etc
3/ once i have selected a route in colum (1) i want to have the dollar value that is associated to that route to show up in column (2)
ex/ route A worth $1
route B worth $2
create a dropdown list but thats about it, i have not been able to link any values together.
View 11 Replies
View Related
Apr 28, 2014
I have an workbook with pictures that are linked to external picture files, and they are placed in the workbook via macro. When I email the file to another computer and open it, the pics do not display and show an error:
The linked image cannot be displayed. The file may have been moved, renamed, or deleted, Verify that the link points to the correct file and location.
I would like to be able to save the workbook with the pictures in them (without having to archive them) so that I can open it and see them on another machine.
View 1 Replies
View Related
May 13, 2013
I was trying to select all of the pictures/objects in a certain range (A294:L1400) in order to move them all at the same time. How do I do this?
View 1 Replies
View Related
May 7, 2009
I am trying to link a range of cells from one sheet that contain various dates to another sheet in the same workbook. Some of the cells are empty. I select the source cells (say, F8-F19), copy, select target worksheet, Paste Special (and select Paste Link button). Target cells display accurate date information that updates as source cells are changed, however, any source cells that were blank now read 1-Jan-04. I have checked to ensure that all source/target cells have the same formatting (Number-Date).
When trying to Paste Special values and/or number formats only, the option to Paste Link is no longer available. How can I link the cells so that blank source cells result in blank target cells? Issue seems similar to: http://www.excelforum.com/excel-gene...worksheet.html
View 3 Replies
View Related
Jun 18, 2013
I have the folloing Sheets("Monday").Select.
I would like to link this to a cell in my excel sheet.
On Sheet 1 i have a folmular which gives me yesterdays day I would like to like this to the cell so i tryed this
Tabname = sheet1.cells(12, 9)
And I have change the above to Sheets(" & Tabname & ").select.
Its giving me a Subscript out of range error.
View 1 Replies
View Related
Jul 3, 2009
I am trying to do is (see attached) have a dropdown with rating of 1 to 5, Col C. A Salary is in Col B. When a perfomance rating has been selected, the increage %age must be picked up according to what salary ragnge the salary falls into, Col D.
View 2 Replies
View Related
Mar 1, 2013
I have a list of expenses on a certain project. I allocate each line to a certain type of expense by using a dropdown list. When re-opening the file, the first few lines were good: dropdownOK.jpg
But after a few lines, the dropdown range changed, although it keeps the selection I made in the previous version: dropdown_wrong.jpg
I have seen that the data validation list changed to =$A$2:$A$17 instead of my separate list =Dropdown!$A$2:$A$17 but cannot understand why excel has made this twist. Each month I update this list, which means adding lines to the list, both inserting them at the bottom, as in between other lines. I can't see any pattern, because it kept the range of the first 6 lines, when the previous version already had 50 lines or so. It does not only happen to the inserted lines, for example.
View 1 Replies
View Related
Feb 18, 2014
There are multiple duplicates of different part numbers in a column. When I autofilter the column, it shows 1 selection for each part number. I am trying to extract this selection fromm the autofilter dropdown box. I want to use it elsewhere in a dropdown box.
View 8 Replies
View Related
Jun 6, 2014
Based on the value (month) picked from a dropdown list, I want to go to the specific range of that month in the same worksheet.
Attached you can find a sample sheet. Map1.xlsx
View 5 Replies
View Related
Mar 24, 2009
I have a list of 800 fund names that can be any one of 6 types of funds. It is easy to filter the names using the filter function, but I cannot get it to be a filtered list for my dropdown box. The dropdown box should only list those fund names of funds that is of a certain kind. I know I am missing something small.
If the accompanying data is used as an example, I would like a dropdown box with the names of all the I funds.
View 2 Replies
View Related
Nov 28, 2012
I have a workbook that has a 50 years worth of daily values for ~30 data streams. Each data stream is a tab, days are in rows with each year a new column. I want to plot selected date ranges of selected data streams from selected years on one page. So I have a tab, "QuickCharts" that has a spinner to change the year and based on that change it pulls in two dozen different data streams (reservoir information, so we're talking Inflow, Outflow, Stage, Temperature, etc at different sites). I have static plot of the entire year's data for each site. This much works fine.
I want to be able to dynamically change the plot ranges, though, with spinners. I created 12 named ranges using this type of syntax:
Code:
=OFFSET(QuickCharts!$Y$3:$AP$367,PlotStart,9,PlotStart+PlotOffset,1)
where PlotStart and PlotOffset are named cells containing a single value.
Things that work:
- I can perform operations on the named range (e.g. =Average(PR_XAxis) works fine)
- I can go to the named range dropdown in the upper left and type the range names in, and the range is selected as expected.
- The named ranges are offered as autocomplete options when typing in cell formulas.
Things that don't work:
- These named ranges don't appear in the named range dropdown list at the top left - I can type them in, but they aren't there by themselves.
- I cannot use those named ranges as series for a chart.
I tried replacing PlotStart PlotOffset with the absoilute cell references. That didn't work.
I tried scoping to worksheet instead of workbook - didn't work.
This seems to be related to this question, but the solution there isn't working for me. Selecting Chart Data Sources Using Named Ranges...
View 6 Replies
View Related
Apr 30, 2014
Say columm Ahas values like:
A1
A2
A3
A3
A1
A2
G5
G5
101
5000
4574
5
Is it possible to have this columm filtered to return a dropdown list say in Cell B1 to show only unique numbers? In the case above would return;
A1
A2
A3
G5
101
5000
4574
5
Almost as in data validation "List".
View 8 Replies
View Related
Jun 18, 2014
I have a list of sites and depending which site I select from my drop down box I want to retrieve that data from my full data sheet. How can I go about doing this?
View 3 Replies
View Related
Aug 2, 2012
I'm new to excel and was trying to make a workbook that will have a drop down list populate based on a user input in two separate cells. Basically, i have columns: name, pages, and books. I would like to have the drop down list match data by first finding the amount of books read, then finding the amount of pages read. Then any name that meets the criteria will be available in the drop down list. How can I do this?
View 1 Replies
View Related
Dec 12, 2013
On the Control Panel sheet of the attached book, I need to load only the non blank cells from BQ3:BQ9 into a data validation drop down.
View 8 Replies
View Related
Mar 8, 2014
I have several different named ranges that I want to sum and the user chooses the range from a drop down box. I want to select the range based on that choice but when I reference the cell that contains the reference to the selected range I get a result ** 0, but no error. I realize I could use several nested "If" statements but I was looking for a more streamlined approach.
here is the formula:
=SUMIF(Regions,B4,worksheet!K13) K13 = the name ** the selected range.
if I put the name ** the range directly into the formula I get the correct result.
View 3 Replies
View Related
Apr 20, 2009
I'm hoping this is a simple question someone might help clear up for me.
I've defined a few cell ranges on a worksheet (in my example I've defined their names as site1, site2, site3, site4, site5). All these ranges are identical in # of columns and rows.
On a separate worksheet, I'm trying to display a single named range, depending on the value in a dropdown menu.
In my example, I have a pulldown menu with the following items: site1, site2, site3, site4, site5 (mirroring the named cell ranges). I'd like to display one of these ranges, depending on which name is selected in the dropdown.
View 6 Replies
View Related
Jul 12, 2013
I attached a sample spreadsheet but I was wondering if there was a code that could display a range based on an option selected in a dropdown box.
excel help.xlsm
View 3 Replies
View Related
Jun 3, 2014
Ok, so I have a sheet with a working drop down list with dates, and depending on the date you choose, certain columns getting hidden and some un hidden. The layout is the same form is repeated 7 times, and which ever date you pick, the corresponding form gets un hidden. My question is, I have a button that will export it to a new sheet with just the values, to be sent to the office. I don't need to send the entire work book and confuse people.
I know how to export, just not using an if then to choose which columns to export.
sample: Attachment 322549
fixed the attachment: added my codes
View 4 Replies
View Related
Oct 30, 2013
I have the following table with weeks to display for the holidays and my column H has a drop down list of the first column in the table below with the Named Range, "SNCODE.Season_Codes".
The other two Named Ranges are, "SNCODE.Season_Codes.Start" and "SNCODE.Season_Codes.End"
I need my column K to display a list of weeks from the first week to the last week. For example, the cell in column K for Valentine's Day should have 1, 2, 3, 4.
Basic 1 53
Promotional 1 53
Seasonal Spring 1 13
Seasonal Summer 10 26
Seasonal Fall 23 39
Seasonal Winter 36 53
Valentine's Day 1 4
Halloween 31 40
Christmas 36 48
View 6 Replies
View Related
Apr 19, 2013
I have data that resembles (I have also attached an example workbook as well if that is easier)
Column A.................Column B................Column C..................Column D.............Column E................Column F
Year.......................Quarter...................Month..................Product-Code...........[data A]................[data B]
2013.........................Q1.........................Jan........................SD-21...................13%......................0.05%
2013.........................Q2..........................Apr........................NV-12...................7%.......................6%
etc
I am hoping to have, on another sheet, a series of dependent drop boxes- Year, Quarter, Month, SKU- which after selecting then displays 'dataA' & 'dataB'.
So you could select- List 1: 2013 ----> List 2: Q1 ----> List 3: Jan ----> SD-21.................and then 13% and 0.05% are displayed.
The data will be continuously added to and so needs to be based on a dynamic data range.
I know that a pivot table is the perfect way to do this, however my bosses have requested that I do not use that format so it is easy for all staff to access.
So I think I need to construct some sort of dashboard sheet, I have experimented with OFFSET from other posts, but so far have had no joy.
View 14 Replies
View Related
Aug 23, 2013
I have a spreadsheet listing various pieces of computer hardware, software and mobile accessories, etc with costs attached.
I have created a dropdown list of staff profiles eg a sales representative, finance assistant, IT administrator.
What I want to do is get Excel to pull the data through from the data sheet, to a printable summary output form (something you could also cut and paste from). For example, a sale rep would need to be set up with a laptop, laptop case, mobile phone, etc, so when you select Sales rep from droplist, I want that action to pull all the associated data through to the summary form. Similarly, a Finance assistant would require different kit , perhaps a desktop PC , monitor , etc.
Next to my data I have created columns with "Y" for yes in cells containing kit that match the staff role requirements, but I am not sure of the best way to pull this together.
View 3 Replies
View Related