Hi everyone,
I am new to using VBA and not totally comfortable with Excel yet.
I have a project where I need to multiply a range of cells with a value that a user inputs in a table.
So if they input the year "2014" in a cell, then the value they input from that year need to be multiplied with another number from 2014, 2015, 2016, 2017, 2018, and 2019. The year they input is different, but all numbers need to be multiplied up until 2019 always.
I have attached a picture of how the excel sheet would sort of look like. The idea is that when another table to the right is added below the others, that the "price in 2019" would be calculated automatically. The calculation is included at the top of the screenshot for clarity.
I have tried some VBA before but when googling how to approach this task I get nowhere. Hope that someone can point me in the right direction And that my explanation makes sense.
Thank you so much.
I am new to using VBA and not totally comfortable with Excel yet.
I have a project where I need to multiply a range of cells with a value that a user inputs in a table.
So if they input the year "2014" in a cell, then the value they input from that year need to be multiplied with another number from 2014, 2015, 2016, 2017, 2018, and 2019. The year they input is different, but all numbers need to be multiplied up until 2019 always.
I have attached a picture of how the excel sheet would sort of look like. The idea is that when another table to the right is added below the others, that the "price in 2019" would be calculated automatically. The calculation is included at the top of the screenshot for clarity.
I have tried some VBA before but when googling how to approach this task I get nowhere. Hope that someone can point me in the right direction And that my explanation makes sense.
Thank you so much.