dynamic reference

I've got the below setup, trying to have a filepath reference the workbook name listed in CurrentIndia, highlighted below. I've named the range officially CurrentIndia in NameManager: But everytime I edit the formula or re-confirm it, the Update Values window pops up everytime, and I have to...

Hello! I'm trying to make a dynamic reference to a closed workbook in my report. Currently, a straight-up hardcoded link looks like this: ='G:\Reports\Management Reporter\[India Trial Balance 2023 in US dollars v2.xlsx]ManagementReporterISbymonth'!J16 My goal is to have the bolded part be...

Hi all, I need to dynamically insert a row into a table based on a cell value. I'm able to insert the row, but I haven't figured out how to make it dynamic. The row will always go above the row with the value "2270PBAKE" in the STAGE column. I'm using the Table.InsertRows function. For the...

Hello, I am looking to pull values from an assortment of invoice formats that will populate a summary sheet (example below). Though location of "Fund" and "Amount" can vary within each invoice (and they don't always begin on row 1), they always contain the same headers. Is there a way to...

Hello All, I am trying to use a Vlookup that when I change an option from the dropdown menu the table changes the range ( A1:A15 to A17:A24) in the source file for the tab and base file name are the same but February will change to March, then April. I am trying to use this formula pieced...

Hello, The Background: I'm currently working with a pivot that is drawing information from a query. The query's number of rows change, so the pivot's does, as well. The number of columns won't change anytime soon. The pivot is located in the CBPivot tab. I'm using Index/Match to pull the...

I have been tasked with creating a large workbook to track productivity for a department across all of the weekday for the year. It must also include a sheet for the year-to-date average production for each member of the department. The way this was done last year by using a new worksheet...

I have the following macro that will take the url address (which is a link to a picture on a website) and create a picture of it on comment field. The problem is that I have to manually change the range of the cells including the urls. I would like to be able to only select the first cell and...

Hi, Hopefully you can help? I am trying to create a dynamic reference in a table name using.. =SUMIF((CONCATENATE("rev_"&E2))[ITEM],"11*",Alacer!F:F) E2 = wk12 Table name = rev_wk12 I am trying to reference the table name by concatenating the name and then addressing column...

Hi all, I have a combobox in a userform, and i want to fill that combobox with table headers. For e.g. Fruits Vegetables Nuts Orange Celery Almonds Apple Cabbage Cashew Pear Tomato Peanuts I want to fill the combobox with "Fruits", "Vegetables"...