K
Kathleen Bell
I have a spreadsheet which has continuing data. Every month I copy the last
month's columns and put the current month's data in it. Once a journal
entry has been made the data cannot change. I woud like to protect the past
months, but still be able to work with the current month's cells. I have
changed the cells to say protect and it does nothing. It says I have to
change the sheet to be protected. When I do that I cannot change the
current month cells. How to I protect the past month and leave the current
month unprotected?
month's columns and put the current month's data in it. Once a journal
entry has been made the data cannot change. I woud like to protect the past
months, but still be able to work with the current month's cells. I have
changed the cells to say protect and it does nothing. It says I have to
change the sheet to be protected. When I do that I cannot change the
current month cells. How to I protect the past month and leave the current
month unprotected?