How can I create a button to save one worksheet into a new workshe
 

I want to create a button on a main worksheet to transfer data and save it
into another worksheet each time the main worksheet is used/filled out for
inventory purposes. In other words, once my employee fills out the
worksheet, they can push the "completed" button, for instance, and it will
transfer into another worksheet.
--
Courtney

"court" wrote:

I want to create a button on a main worksheet to transfer data and save it
into another worksheet each time the main worksheet is used/filled out for
inventory purposes. In other words, once my employee fills out the
worksheet, they can push the "completed" button, for instance, and it will
transfer into another worksheet.

Is the second worksheet the same on each occasion, or is it new every time?

The second worksheet would be the same on every occasion.
--
Courtney


"bigwheel" wrote:

"court" wrote:

I want to create a button on a main worksheet to transfer data and save it
into another worksheet each time the main worksheet is used/filled out for
inventory purposes. In other words, once my employee fills out the
worksheet, they can push the "completed" button, for instance, and it will
transfer into another worksheet.

Is the second worksheet the same on each occasion, or is it new every time?