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