In the Daily Reporting Tab there are multiple items highlighted Yellow.
These cells will be uploaded daily...
The gray cells will be copied into the monthly reporting Tab according to the date that is highlighted in Yellow.
The monthly reporting tab takes the Information for that day and inputs it onto the calander like spreadsheet.
The Problem:
Right now im using If Formulas between tabs. I need something that will update the spreadsheet by removing all the manual Data from the daily reporting Tab, and keep the value for that day in the monthly Reporting Tab. this way when I change the date going forward, I dont lose the Monthly info.
These cells will be uploaded daily...
The gray cells will be copied into the monthly reporting Tab according to the date that is highlighted in Yellow.
The monthly reporting tab takes the Information for that day and inputs it onto the calander like spreadsheet.
The Problem:
Right now im using If Formulas between tabs. I need something that will update the spreadsheet by removing all the manual Data from the daily reporting Tab, and keep the value for that day in the monthly Reporting Tab. this way when I change the date going forward, I dont lose the Monthly info.