Hello all,
I work as a fund accountant in the private equity industry and we rely heavily on Investran OLE DB reports for financial data. To best ask my question I think I should give a scenario:
Sheet 1 - Main tab
Sheet 2 - Data Tab
Sheet 3 - Driver #1 : Investran OLE DB Report with the following parameters
Sheet 4 - Driver #2 : Investran OLE DB Report with the following parameters
My question is: How can I create a macro that with the press of a button, automatically refreshes Sheet 3 & 4 (Investran OLE DB Reports) using the parameters in sheet 1 (main tab). I've been able to create a macro that will refresh the entire workbook, however, I still need to manually enter the parameters on sheet 3 & 4.
Any help would be appreciated.
Thank you.
I work as a fund accountant in the private equity industry and we rely heavily on Investran OLE DB reports for financial data. To best ask my question I think I should give a scenario:
Sheet 1 - Main tab
- Cell A1: Fund name (from a dropdown menu)
- Cell A2: End Date
- Cell A3: Start Date
Sheet 2 - Data Tab
- This tab will have formulas that link to Sheet 3 & 4
Sheet 3 - Driver #1 : Investran OLE DB Report with the following parameters
- Fund Name
Sheet 4 - Driver #2 : Investran OLE DB Report with the following parameters
- Fund Name
- End Date
- Start Date
My question is: How can I create a macro that with the press of a button, automatically refreshes Sheet 3 & 4 (Investran OLE DB Reports) using the parameters in sheet 1 (main tab). I've been able to create a macro that will refresh the entire workbook, however, I still need to manually enter the parameters on sheet 3 & 4.
Any help would be appreciated.
Thank you.
Last edited: