Update prices based on list value
Hello,
I would like to create a dynamic document that increases prices based on the year, the year being selected from a drop down list.
I want to use this year as the starting point prices and apply an increase of 5% going forward so that when I change the year on the drop down list the prices go up by 5% per cent based on the previous year.
All I have so far is a table with prices for various item A4:D40 and the drop down list with the years in G2.
I have been looking around for solutions but I can’t find and answer.
Thanks.
Hello, I would like to create a dynamic document that increases prices based on the year, the year being selected from a drop down list. I want to use this year as the starting point prices and apply an increase of 5% going forward so that when I change the year on the drop down list the prices go up by 5% per cent based on the previous year.All I have so far is a table with prices for various item A4:D40 and the drop down list with the years in G2.I have been looking around for solutions but I can’t find and answer.Thanks. Read More