table column name

  1. J

    VBA select table column based on a named range variable

    Using VBA I am trying to save data within a table column into a saved column, the difficulty is the column to copy the data from changes each month as it is time related. As an example the column titles are of a standard naming convention based on their type and the month e.g. "Cost Apr-19"...
    • Jasp30
    • Thread
    • column cost named table column name vba named ranges
    • Replies: 0
    • Forum: Excel Questions
  2. H

    Dynamic in finding column name in formula

    Hi Team, I need some option or solution to my query. I have dataset which define with table and given table name and total column consists of 10 and this is not fixed tomorrow when I get fresh data the number of columns may get increase to 11 or 12. I created few formulas based on the table...
    • harinsh
    • Thread
    • column table table analysis table column manipulation table column name
    • Replies: 3
    • Forum: Excel Questions
  3. D

    Copy specific table columns from one workbook to another

    Greetings, I am looking to copy a few columns from a table in another workbook without specifically referring to the sheet name if possible. This is the code I have that works Sub Export_SomeData () Dim myBook As Workbook, newBook As Workbook Set myBook = ThisWorkbook Set newBook =...
  4. F

    Help with shifting table columns

    So, I have a main excel doc with a (smart?) table on it,and I’m constantly add more columns into it. this wouldn't be a problem ifother excel files didn't pull data from the main doc. whenever I add in anew column, it breaks all the formulas on the other doc. tables have specialname for columns...
  5. F

    Directly reference table column in chart

    I'm looking to reference a table column for my chart data, =Workbook1.xlsx!Table1[Values] If possible it would be even better to be able to dynamically change the table name using the INDIRECT formula: =INDIRECT("Workbook1.xlsx!Table"&$A$1&"[Values]") where A1=1/2/3/etc. Currently the only...
    • FarazM
    • Thread
    • chart reference dynamic cell references named range table column name
    • Replies: 1
    • Forum: Excel Questions
  6. M

    I've got a real tough one here. Need countifs & some weird combo of index/match ?

    Hi everyone, Let me first start off by saying that this is my first post here on the forum. I've lurked for a while now and answered all of my questions via the helpful and extremely courteous nature of everyone responding to others plea's for help. I'm unfortunately stumped beyond reason here...
    • Mochadrone
    • Thread
    • countifs index count array match and difference medianif table column name
    • Replies: 8
    • Forum: Excel Questions
  7. R

    Select last cell in a certain column in a table

    I want to create a function returning the count of contiguous non-blank/non-zero cells at the bottom of a column in a table. My thoughts are to first select the bottom cell in the "Table1" in the column named "Rem". Starting there, I would loop through each cell above, increasing a counter by...

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