Need help with Microsoft Excel VBA macro that will add a row based on value found. This is a 1 of 3 part series of questions I have.
Please note ee sample.xlsx (Sheet1 only)) file as I ask this question. The ee samplefinished.xlsx is the final version that completes as my answer.
Basically I identify the latest year in column A. by finding the cell value of 'Curr' - storing the value of what the year is in a text variable - then add a new row.
Within the new row created, I add a plus +1 to that year and place it in column A. and then ensure the totals below the new row contain the =sum equation.
You'll notice the =SUM equation in ee samplefinished.xlsx contains the newly created row 10 in Excel vs in contract ee sample.xlsx. This is what I'm trying to accomplish.
Can someone please help me with some sample Excel VBA macro code that will make this work? I'm including Microsoft Access VBA experts as well that probably has done this before. Right now at this time do not want links to other internet forums/ articles that may guide me in the right direction to solve this but just purely some sample code I can copy and paste and see if this will work. (Currently researching other solutions for other coding problems and don't have time to look it up).