dynamic address

  1. K

    Dynamic Sum Range Addresses...(?)

    I'm not really sure what you'd call what I'm trying to do, but here's my best attempt to describe it. I'm creating a summary sheet that will pull from an unknown number of sheets. I've employed Indirect to assist me as I hate #REF errors should referenced sheets get deleted. I have my macro...
    • Kenny_D
    • Thread
    • dynamic address for...next loops vba vba formulas
    • Replies: 2
    • Forum: Excel Questions
  2. K

    Dynamic Address for Use in Function Always returns ERROR

    I'm trying to create a Federal Employee Calendar. I've historical dataset of the Federal Holidays since 2017 going till the year 2030 as shown below: ABCDEFGHIJKLMNO1Federal Holidays by Year201720182019202020212022202320242025202620272028202920302New Year’s...
  3. S

    VBA/Formula to reference a Closed Workbook, based on a Dynamic cell reference in current workbook

    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...
    • SirGruffles
    • Thread
    • closed workbook lookup dynamic address dynamic formula dynamic formula to reference external workbooks dynamic reference help no indirect vba
    • Replies: 3
    • Forum: Excel Questions
  4. I

    SUM cells with a specific column header from multiple worksheets - Using VBA

    Hi All Good people I'm new to VBA and I'm seeking some assistance with a macro. I have a workbook with multiple sheets. First worksheet is call master worksheet. In the master worksheet I have sheet names. I would like to sum all cells below a specific column header named, "My text." across all...
  5. A

    VBA/Macro - Dynamically add hyperlink

    Hi, Can anyone help with this: Data range: Range (A2) to last row in column G Worksheets: Main - SUMMARY (column H is where i'll put hyperlink - with header) Other worksheets Criteria for address: 1. column I (my helper column) of SUMMARY equals Worksheet name (select) 2. Value in column A...

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