Hi everyone,I was hoping to visualize data from a forecasting model in three areas: Office Workstations, Headcount and Office squarefootage. My company is looking at building needs over the next five-years for approx. 20 locations across the US. I have a spreadsheet that I was hoping to use the up/down to show the location and year in each of the three areas, to visualize the increase or decrase and it's trend percentage. Contact me at my email address and i can supply you with an example for the video screencast.

If you can provide us with some raw data for Office Workstations, Headcount and Office Square Footage we would be happy to put together a tutorial explaining how to configure an UP/DOWN type dashboard to communicate this information in a clear and functional way.

Just for your information, our policy is to keep communication via the forum rather via email - the logic being that everyone gets an opportunity to learn from the tutorial examples that are posted here.

I want to use Data validation and V Look up so that when I pick a date from a drop down menu it automatically updates the dails with information from that date? Is there a video that shows this please?