referencing tables

  1. J

    VBA: 2 specific problems: 1 - set table row as range and 2 - refine existing code

    Hi all Below is a bit of code. I prompt user to select a cell (although so far its possible to select more than one but I'll fix that) as starting point from which a table will be inserted. Then I prompt for user input to specify the range in a pivot table frequency array formulas calculations...
  2. I

    A dynamic indirect function..?

    Hi all, I have tried to search for an answer, but with no luck! In a spreadsheet I have a tab named 'ProjectsSummary' which holds a table called 'tbl_ProjectSummary'. Within that table, there is a column called [Project Name] which has a list of all the projects I am tracking. Within the...
    • in_d
    • Thread
    • indirect ranges referencing tables sumproduct
    • Replies: 2
    • Forum: Excel Questions
  3. D

    Using two data validation lists to select element in array

    I am trying to use two seperate dropdown lists to select a specific value in a table of set values. The first drop down will select the row and the second will select one of two columns. I have the data validation lists ready to go but it looks like the main hangup I'm getting is having the...
    • deucekhk
    • Thread
    • data validation dropdown box referencing tables vlookup
    • Replies: 4
    • Forum: Excel Questions
  4. R

    Excel 2010 / automatically update table column in another sheet

    Hi, This seems fairly easy, but I haven't had much luck with searching for the answer on the web. I have an Excel 2010 table in Sheet 1 (FYI, table has headers with 11 columns). In Sheet 2, I would like to continually reference a particular column (Column 1) and its rows from the table in Sheet...
    • rgs694
    • Thread
    • different sheets excel 2010 referencing tables
    • Replies: 0
    • Forum: Excel Questions

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