name ranges

  1. S

    Creating a named range that will refer to the total range of multiple other named ranges.

    For example I name A2:A5; "test_a" I name A6:A10; "test_b" I want to create a third named range "test_c" which then includes the {sum} area of "test_a" and "test_b" Context / Rationale I tried to create a named range that includes many (80 plus) non-contiguous named ranges. Strangely even...
  2. M

    Pivot Tables and Named Ranges..any benefit in reducing file size?

    Hello everyone, I've searched the web and the forum on this one but am having trouble getting an answer. Can anyone tell me if there is a benefit in creating a named range for a data set which is then used to create a lot of Pivot Table reports from on a weekly basis? In the past few months I...
    • MarieTherese
    • Thread
    • large workbook size managing large datasets name ranges pivot tables
    • Replies: 3
    • Forum: Excel Questions
  3. S

    Macro to name ranges based on the value of two other cells

    Hi, I know it should be simple enough, and I have seen many similar Q&As on this sort of topic. But I couldn't find one that solved it for me, and I couldn't work it out by myself. VBA is not my strength (yet). I want to name hundreds of ranges. I don't want to type the name myself. Ideally I...
  4. S

    Copy name range from a sheet to another sheet in the same workbook when it matches a criteria

    Below is the 1st step of my code. It list the name of the different ranges in the workbook into sheet("D_RANGES"). The user will then manually edit this list in sheet2 as not all the ranges are needed. Basically, this list will change every time. The 2nd step of copying the value of the...
  5. B

    ClearContents

    I need to clear contents of several different ranges with a loop. I've done some research but cant figure out how to do it. All the ranges that need to be cleared are named ranges (JobSpecs, JobInfo, JobTest, EmailAddress). I know this is simple but I cant seem to get it right. Can someone...
  6. C

    Table If and Vlookup

    Hello, I have a table of data, which is updated daily. This is a full upload, not delta. Against each line i have formula for various status, which are then returned in Pivot tables. All works well for the Business i am in. But i need to enter a IF combined with a VLOOKUP. I have not had a...
    • craig80
    • Thread
    • if statement calculations name ranges tables vlookup
    • Replies: 2
    • Forum: Excel Questions
  7. R

    Add series automatically to a graph

    Hi, I'm wondering if you can help me. I've got a graph which feeds from a worksheet with a varying number of rows. I need a VBA code to insert a new series into the graph whenever a new row is inserted into the table on the worksheet. My initial thoughts were to name each row SeriesData(i)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top