Greetings,
I created 4 different tabs (‘Work’, ‘School’, ‘Home’, Volunteer’) with the same type of information (Date, Hours of Homework, Length of Break, and Sector) on each tab. For further reference, see the attachment for example.
Additionally, I created a data validation list from these tabs.
My questions are:
(1) How do I create formulas that list the respective information (date, hours of homework, time length of break, and sector) from the selected tab?
For Example: If I select Volunteer, I want all data from the 'Volunteer' tab to populate in the blank field on the ‘Report’ tab.
(2) Once the data is populated and I am able to toggle back and forth between my 4 choices (Work, School, Home, and Volunteer), is there a way to create a line chart (graph) that displays hours of homework AND time length of break from the listed dates?
This is a pretty in-depth request. Any feedback is much appreciated. Thanks!!!
PLEASE IGNORE ATTACHMENT IN THIS MESSAGE,SEE NEW ATTACHMENT LISTED BELOW
Bookmarks