Forum Discussion

Copper Contributor

Jun 21, 2022

Excel VBA

How to create a performance sheet with IRR for a list of companies using excel VBA. Data for the performance sheet will be from two different excel files, which are updated on a monthly basis.

excel

Formulas and Functions

Macros and VBA

mathetes

Silver Contributor

Jun 21, 2022

Aaaam

You've had over 40 views of your request without a single reply. I can confidently state that the issue here is the lack of a complete description. In order to have IRR or XIRR (which I use in an investment tracking workbook) one needs a series of dates and cash flows. Do you have that? What are the two sheets that are updated monthly? Etc.

Lots of questions that need to be answered; those were just starters. Why do you specify "using excel VBA" for that matter? It's entirely possible that Excel functions and formulas may suffice.

If it wouldn't be violating some proprietary restrictions, you'd also help us help you by posting copies (or mockups) of the various sheets in question, either on GoogleDrive or OneDrive, and then granting access via a link posted here.