Hi, new here.
I have searched the forum as instructed prior to posting, but have not been able to find what I am looking for.
I have a workbook with 12 sheets, with sheet number 1 being the master. Here is what I want.
I want to lock cells on sheet 1, until the required cells in sheets 2 thru 10, either all or a combination of, are populated.
Then I want sheet number 1 to auto populate with the date, when, and only when, those required cells are satisfied.
It makes sense in my head and when I am looking at it, but I may not be explaining it correctly!
Thanks for any help
I have searched the forum as instructed prior to posting, but have not been able to find what I am looking for.
I have a workbook with 12 sheets, with sheet number 1 being the master. Here is what I want.
I want to lock cells on sheet 1, until the required cells in sheets 2 thru 10, either all or a combination of, are populated.
Then I want sheet number 1 to auto populate with the date, when, and only when, those required cells are satisfied.
It makes sense in my head and when I am looking at it, but I may not be explaining it correctly!
Thanks for any help