NNewcomerNouramishaalRegistered on:09/02/2025Last activity:09/03/2025 at 12:24Version of Excel:2019Posts1Votes0Files0Downloads0ThreadsPostsStatisticsVotes received Threads Created by NouramishaalDateForumThreadMessage Excerpt09/02/2025 at 23:07Excel - VBAHow to Automatically Update Formulas or Ranges When New Rows Are Added EachI'm an investment analyst and new to using VBA. I have a spreadsheet where I add new data every month (one new row each time). I want to use VBA to: Find the last row with data Automatically extend formulas to include the new row Update named ranges or charts so they stay current What is the best wa...Forums