scottmcclean
New Member
- Joined
- Jul 2, 2014
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi there, i am trying to build a scenario tool that allows me to select a product and a year so that I can do a % increase or decrease. But the % change will need to start based on the “product” and “year” selected by the user. I have an array that contains rows of products and columns of annual sales data.
The idea is that a user selects a relevant product and the year from drop down lists which then identifies the right place in the array. Then the value in that cell has the % increase or decrease applied to it based on a % specified by the user.
I hope this makes sense?
Many thanks for any assistance
The idea is that a user selects a relevant product and the year from drop down lists which then identifies the right place in the array. Then the value in that cell has the % increase or decrease applied to it based on a % specified by the user.
I hope this makes sense?
Many thanks for any assistance