Is it possible to have 2 sheets in the same workbook that will update the data both ways.
For instance:
My Monday sheet having all the data for all staff hours, and My Sharron Sheet having only the data for Sharrons hours.
If I edit the data on the Monday sheet it will show up in the Sharron sheet and if I edit the data in the Sharron sheet it will show up in the Monday sheet.
Or should I create a form that shows the Sharron Data with the source being the Monday, Tuesday, Wednesday, Thursday, Friday Sheets? So that the form will enable me to see just Sharrons data on each of the Monday, Tuesday, Wednesday, Thursday, Friday sheets.
Bookmarks