Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to make a macro to clear multiple cells from multiple worksheets?
i've got a protected document (can be unprotected if need be) in which
my employees fill out emission events daily. every day they must go through every worksheet in the workbook to erase everything entered the previous day. if they miss something it causes some reporting errors. how can i create a macro which clears out the specific cells i select from every worksheet in the workbook??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO AND MULTIPLE WORKSHEETS | Excel Worksheet Functions | |||
macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Use a macro on multiple Worksheets | Excel Discussion (Misc queries) | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions |