table reference

Good afternoon, I need to be able to change the filter range by referencing a single cell BN2 = [Jan 23]. The difficulty is the table reference, FeesInvoice[ x ] (Cell Reference BM4) =FILTER(FeesInvoiced[Project Number],FeesInvoiced[Jan-22]<>0) (Cell Reference BN4)...

Hi, I am having quite a time figuring how to make this work.. I have a Sheet with a very big table data base with several columns. The table is basically a budget calculator for my engineering projects. I ve created some buttons with recored macro for easier (one click) filtering. All works...

I am very novice to VBA and table references are new to me. I have a macro that needs to go loop through every row of a table and determine the value of each cell in a specific column. That column is subject to change depending on other factors in the macro. I have a variable which captures the...

Hi All, Apologies for the dreadful title, I'm not sure how to explain this succinctly, part of the reason I can't find a solution online for what I'm sure is a simple problem I'm having. I'll explain the setup first: In Sheet 1 I have a basic layout in which Column A is the name of a business...

I made a form with 3 different Combo Boxes, "Age, Gender, Coverage" I want to be able to apply the selected items to a sheet but I only need the value of the table when all three are applied to populate the cell in the sheet. For example: I open the form, select "Male, 18, 250K" click button...

Hi, I have the same table in two different sheets, both formatted as tables. Both of the tables have a column named "PA ID". I have a column where I want to calculate something based on this PA ID, and the reference is different. In the first the reference has to be: [@PA ID] In the second the...

I have a very large table in MSAccess that I imported into my Excel data model. Now I want to write the code to look up some values in the table to put it on a userform. I have written code to get values from tables in Excel, for example: Worksheets("ProjectPlans").Activate With...

Hi I have been googling and googling for a long time now but cannot find any other with the same issue as me. I have a table (tCableData) with a lot of columns. I'm then doing some lookups in this table to use data from this table on other sheets. I insert a formula like this (in another...

I'm trying to map out pathways within my data set. I have 2 stages of what can happen and where so I'm running a countif function that looks at location 1, what happened at location 1, location 2, what happened at location 2. I have 5 variables on location and 10 on what happens with over...