I need to alter the 'GetNewFile' code in VBA in the attached spreadsheet so that when the Target Import File button is clicked a new file is imported each time. At the moment it shows the location of the new target file in the button but when 'Import Data' is clicked it still imports the previous file. I have attached the spreadsheet containing the macro and also the two excel files containing the information that I want to import into the spreadsheet.
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.