Forum Discussion
Updating a sheet by copying text from a cell to another cell after a day, for archiving purposes
I have two sheets in a file. Sheet 1 containts the daily meeting items. However, this is only the case for the last 5 workdays. Monday is B2. Tuesday is B5. Wednesday is B8, et cetera Every morni...
This method is exemplary when VBA/macros are not an option, and since external automation isn’t possible with Teams, a manual approach will suffice. You could also add a note at the bottom of Sheet 2 to remind users to update the sheet daily, ensuring everyone stays on the same page.