How do I set up a macro to automatically delete certain cells?
I have a list of items in a column. (say 20) I would like to be able to
enter an "x" in the cell to the left of certain items (say 4 of them) and
then run a macro that will delete the items. Does anyone have any ideas? I
need to be able to indicate with an x which items are no longer valid and
then run the macro at the end of a shift and clear just those items marked
with an x. Thanks!
|