I have a template for inventory movement. I want to create a macro to give
each new document a unique number. I want the number to be in cell B4. I
have created a macro in word, but I can not figure out how to do this in
excel. I am a novice and would appreciate any assistance on the process of
creating the macro and what syntax to place in the VBA editor.

Thanks.
--
Jeff W