Use Sheet to complete Summary sheet or vice versa
I'm trying to figure out how to have information populate a grid from the summary tab or for the Grid to update the summary tab. The reason I am needed this information in the summary tab is that I am linking this to some dashboard widgets that I need to change as the project changes. If I'm entering information into the summary tab,
I want it to add a new row having the former row status change from current to past and the new row to be current with the information added.
I appreciate any help.