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?