defined name

  1. S

    Show different worksheets with Camera Tool but the ability to edit data shown?

    Using this YouTube video as a guide https://www.youtube.com/watch?v=lCsvSdk4Tro I have created a Dashboard of sorts which has a Dropdown box and this shows data from numerous sources. The sources are mainly Pivot Tables but is there a way to actually edit whatever is being shown in the Camera...
  2. K

    Hyperlink formulas disappearing after a running code

    I have a spreadsheet with nearly 5000 defined names. We have a code that transfers filled out information from the template, to the most recent release of that template to capture any changes in sale prices or new items. So they are both the same spreadsheet except the most recent template has...
  3. K

    Defined Names contain autofilter ranges?

    I want to loop through all of the defined names pertaining to my sheet. That's the easy part, the issue i am encountering is that the workbook's many auto filter ranges must be stored as a defined name, which is not want i want. None of those filters were named intentionally. And the code i'm...
  4. L

    Display the "Defined Name" of a cell in a cell when the cell reference is in a cell next to it??

    Hello, I created a scenario summary and in the Result Cells column, all I get is a cell reference. Is there any way I can do a look up of that cell number located in the other tab so that the "Defined Name" of that cell displays where I wrote the "?"? I've been searching the web for days, no...
  5. E

    Differences Between Defined Name Scope In Formulas And In VBA

    While playing around with defined names I found some behavior that seems to be inconsistent between using defined names within a formula in the workbook environment and defined names within the VBA environment. I have two questions: Can others duplicate this behavior? If others can duplicate...
  6. S

    Listing the named range values

    Hi All Im getting a bit lost on what im trying to do here I have the named range value in Cell D5 and this range changes dependant on other dropdowns, which then creates a data validation list in a tabular from im building, but i want to build a summary table where the list of values in that...
  7. K

    Variable Shape lookup using defined name - works only with anchored cells in match function

    I have an Excel problem I cannot seem to solve. I am trying to do a dynamic shape/color change based on a percentage, the index of shapes and matching percentages are in B10:K10 and B11:K11. Defined Names - Status =INDEX(Sheet1!$B$11:$K$11,MATCH(Sheet1!$M$11,Sheet1!$B$10:$K$10,0))...
  8. tycasey17

    Two Formulate List Merged into Data List

    Can two list that have a Defined Name be merged to be used in the Data Validation as a dropdown list?
  9. K

    Accessing Defined Names in VBA

    I would like to access some defined names in my VBA code. These names have a ReferTo value that is a formula. For some the formula evaluates to a single value, like 5005 or "The Client", and for others the formula evaluates to a range. After quite a bit of searching I haven't been able to find...
  10. R

    Define names based on cell content (multiple cells per name)

    I am attempting to define names for all cells in an entire column of a range. In this column, there are repeating values, which are always next to one another, by design. What I am looking to do is to have each set of cells that have the same content (again these cells are next to eachother)...
  11. N

    GetPivotData getting #REF error while worksheet is being replaced in VBA

    Hello, I've created a PivotTable with VBA which works fine. The problem is that when I delete and create a new pivottable on a new worksheet to update the values, all of my formulas on an existing worksheet end up with the #REF error. I need to reference this PivotTable to do a VLookup of...
  12. R

    Find text and return address of the found cell on another worksheet (reference by cell in current worksheet)

    I'm trying to do something that I thought was going to be simple; however, it's turning out to be a pain. I have 2 worksheets, sheet1 and sheet2. In sheet 1 I have a list of all of the worksheets in my book populated via a formula. In an adjacent column I want to return the address ($A$5) of...
  13. M

    Simple loop based on Defined Name

    I am having a problem with a simple loop that I want to run x number of times based upon a defined name in a worksheet. My defined name is Clients=counta($A:$A)-9 I have a macro that I am trying to execute that will copy a range down a number of times based upon the value found in the defined...
  14. E

    Change the scope of a Defined Name in Excel 2007

    Hi, I have a sheet with 20 column and wanted to use the column headers as names, so I opted the Create name from selection option. It was a breeze to create so many names so quickly, but the problem is the scope of the names was set to Workbook. Is there any way to change the scope from...
  15. U

    Deleting Names from a Different Workbook

    Hi guys, Having some trouble deleting defined names from my workbook which were actually created in an entirely different project! 1) How the hell did they even get in there (pretty sure the workbooks weren't open at the same time)? 2) Why can I not delete them - the delete button is greyed...
  16. S

    Deleting defined name results in Runtime error 1004

    Hello, everyone. I am trying to delete a named range and then delete the defined name also, so that my name manager is not full of old names. I recorded my actions while trying to delete a range called "Area2." The code that was recorded was: Sub Delete_Named_Range()...
  17. C

    How to define multiple groups with data in the same column

    Starting with a spreadsheet full of data. In Column "A" contains the "production line" , column "B" contains the "production date", Column "C" contains the "Product" and column "D" contains the response data. Is it possible to use "defined names" to create multiple groups which could be...
  18. H

    How to formulate no-blanks array formula?

    In my worksheet I have a table (RECIPES) with a list of ingredients in column A (A2:A50), a list of recipes in row 1(B1:K1), and the quantity of each ingredient required for each recipe in the range (B2:K50). On a different worksheet I created a new table (DAILYMENU) and in row A1 there is a...
  19. L

    (Excel) Define several incremental cells' names at once

    Good morning folks! I am trying to rename a row of cells with incremental names. Ex. A1=Results1, A2=Results2, A3=Results3, ...., AN=ResultsN Of course, it can be done by setting names for each cell separately but it takes ages. I would like to know if this is possible to do that quickly...
  20. T

    conditional format where formula uses a defined name

    I've researched through the forums and haven't found a specific answer, so my apologies in advance if I just didn't look hard enough. I want to highlight cells that contain formulas that reference a specific defined name. The purpose is to show where that define is being used, and where it's...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top