Automate 'Previous Week Update' information from one sheet to another....options.
Trying to find an automated way to pull data from one cell to another so I can then reference it as 'Previous Week' back on the main sheet. For example: Sheet 1 will have a column named 'Key Activities Completed this Week'. I'd like that information weekly to be copied to another sheet. I'll then reference this cell in the main sheet as 'Previous Week Activities Completed'. Since we can't automate copying a cell value within the same sheet. If there's anyone who has a better way of doing this I'd appreciate the insight!
Help Article Resources
Check out the Formula Handbook template!