I have 7 worksheets (monday to sunday). On the top corner i want a kind of wall sticker based on a table in the 8. sheets. Ex on the 3. of may i type in: -Empty trash- in the table. The wallsticker on every other sheets says: Empty trash. On the 5.of may i type in: clean windows. Then the wall sticker says the same. The problem is that i want to have the previous actions in the 8.sheet as a historylog.
The wallsticker needs to check ex column B and pick the last cell that has been written in.
Hope you understand, my english is not the best.
Any input will be appriciated.
Thanks
Bookmarks