That is very possible. Obviously more info would be required. My only caution
is that you need to be very careful deleteing things. There is no Undo on a
macro so deleted is deleted... No turning back. I normally avoid deleteing. I
will make a copy of the original and delete from the copy or something
similar...
--
HTH...

Jim Thomlinson


"Bill K" wrote:

I'm not new to Excell but I have never used VBA to create and run a macro. I
am trying to create a macro to perform various functions in a workbook when a
cell is clicked on.

I am working with an inventory workbook and I want to move values from one
column to another on a worksheet, then zero the contents of columns in other
sheets in the workbook.

Is this a viable routine or am I expecting too much?

Any help would be most welcome.

thanks

Bill