Hi
I'm looking to be able to clear the contents of lots of specific cells across two sheets on a daily basis at 1am.
Sheet 1 = Nights
A4:A7, B7, B9:B36, C9:C36, D9,D36
Sheet 2 = SDR
B4:B6, C4:C6, D4, A11,B11,C11,D11, A16, B16, C16, D22, D23, D24, D25, B31, C31, B35, C35, B40, C40, A45, B45, A47, B47, A51, B51, A53, B53, A58:A61, B58:B61, C58:C61, D58:D61, B65:B68, C66, C73:C77, D73:D77, E81:E87, E90, B91:B95, B97:B101, C91:C95, C97:C101, C105:C119, D105:D119, A123,B123,C123,D123
There are also text boxes that i would need to clear as well
I really appreciate all the help you guys give
Thank you in advance
I'm looking to be able to clear the contents of lots of specific cells across two sheets on a daily basis at 1am.
Sheet 1 = Nights
A4:A7, B7, B9:B36, C9:C36, D9,D36
Sheet 2 = SDR
B4:B6, C4:C6, D4, A11,B11,C11,D11, A16, B16, C16, D22, D23, D24, D25, B31, C31, B35, C35, B40, C40, A45, B45, A47, B47, A51, B51, A53, B53, A58:A61, B58:B61, C58:C61, D58:D61, B65:B68, C66, C73:C77, D73:D77, E81:E87, E90, B91:B95, B97:B101, C91:C95, C97:C101, C105:C119, D105:D119, A123,B123,C123,D123
There are also text boxes that i would need to clear as well
I really appreciate all the help you guys give
Thank you in advance
