I work for an emergency management group and I need to figure out a way to do two things simultaneously: 1) automatically fill in three cells (County, RPC, and VTrans district) after selecting a town from the drop down menu and 2) auto-fill in the current time and date as soon as selection is made. I have attached the basic file for those who want to see. This document will be used during emergency situations to help report situational awareness throughout the state. The file contains two worksheets - Report and Selection.
My overall goal: I would like to see Report Column A (Date and Time) automatically inserted after selecting a town in the dropdown menu of column B and have Column C,D,E, automatically populated with from the matching County, RPC, and VTrans District (Selection) associated with the town. Please look at my attachment to better understand.
Any help would be greatly appreciated. Many thanks in advance.
Lou
Bookmarks