49thParallel
New Member
- Joined
- Nov 30, 2017
- Messages
- 2
Hi Everyone,
So I have been having an issue with figuring out the best way to display some data after some user input through a drop down list. To give you an idea of what I want I currently have in mind as an end result, this is what I would like it to look like in a word document or excel table for easy copy and pasting of values into word:
<tbody>
</tbody>
What I want the user to do is select the most recent date (or any date) and have it display that date and the previous 3 years afterwards in the rows beneath. From there I want the user to select a location (City, State, Country) for the next three columns, each displaying the data that corresponds to the location and the month/year. The last column would just be an IF statement that I don't need help with but I have never used dropdown lists that pull data from specific dates.
Just looking for a slight nudge to get me going in the right direction as I've enjoyed researching but have hit a brick wall.
Thanks in advance!
So I have been having an issue with figuring out the best way to display some data after some user input through a drop down list. To give you an idea of what I want I currently have in mind as an end result, this is what I would like it to look like in a word document or excel table for easy copy and pasting of values into word:
Month/Year | Location | Location | Location | Higher or Lower then Location 1 |
November 2017 | 7.0% | 7.0% | 7.0% | Higher |
November 2016 | 7.0% | 7.0% | 7.0% | Comparable |
November 2015 | 7.0% | 7.0% | 7.0% | Lower |
November 2014 | 7.0% | 7.0% | 7.0% | Significantly Higher |
<tbody>
</tbody>
What I want the user to do is select the most recent date (or any date) and have it display that date and the previous 3 years afterwards in the rows beneath. From there I want the user to select a location (City, State, Country) for the next three columns, each displaying the data that corresponds to the location and the month/year. The last column would just be an IF statement that I don't need help with but I have never used dropdown lists that pull data from specific dates.
Just looking for a slight nudge to get me going in the right direction as I've enjoyed researching but have hit a brick wall.
Thanks in advance!