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.
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.
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?
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
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".
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.
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.
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
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.
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.
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.
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.
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...
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?
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?
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.
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.
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.
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.
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.
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.
