How do I add a command button on a worksheet to "paste" from the .

I am making an excel spreadsheet and I want to create a command button on the
sheet itself to where a user can go to another area, copy materal, come back
to the worksheet and click on the command button to paste information onto
the sheet to a specific cell without using keyboard shortcuts or the mouse..
Is this possible and how?

sheets("sourcesheet").range("a2:x200").copy
sheets("destinationsheet").range("a1")

--
Don Guillett
SalesAid Software
donaldb@281.com
"Jalifid@hotmail.com" <Jalifid@hotmail.com@discussions.microsoft.com> wrote
in message news:ACF32CF2-5218-46B9-B5D7-95112FCF06B4@microsoft.com...
> I am making an excel spreadsheet and I want to create a command button on
the
> sheet itself to where a user can go to another area, copy materal, come
back
> to the worksheet and click on the command button to paste information onto
> the sheet to a specific cell without using keyboard shortcuts or the
mouse..
> Is this possible and how?

Thanks... One problem... Tell me if I am doing this wrong... I went to the
"control toolbox" and clicked "design" and dragged a "control button" to the
sheet.. doubleclicked the button to get to the Visual Basic and copied and
pasted the formula into the Private Sub CommandButton1_Click ()... I changed
the "sourcesheet" to "sheet1" because that is where I am going to have the
button, but what do I need to change the "destinationsheet".range("a1) to?
Thanks again.. This is new to me..

"Don Guillett" wrote:

> sheets("sourcesheet").range("a2:x200").copy
> sheets("destinationsheet").range("a1")
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Jalifid@hotmail.com" <Jalifid@hotmail.com@discussions.microsoft.com> wrote
> in message news:ACF32CF2-5218-46B9-B5D7-95112FCF06B4@microsoft.com...
> > I am making an excel spreadsheet and I want to create a command button on
> the
> > sheet itself to where a user can go to another area, copy materal, come
> back
> > to the worksheet and click on the command button to paste information onto
> > the sheet to a specific cell without using keyboard shortcuts or the
> mouse..
> > Is this possible and how?
>
>
>

The parameters should be changed to suit in terms of ranges and sheet names.
For the destination sheet, change the name to the sheet where you want to
copy to. If all is on the same sheet, you may simply omit the sheets("")
part.

--
Don Guillett
SalesAid Software
donaldb@281.com
"Jalifid@hotmail.com" <Jalifidhotmailcom@discussions.microsoft.com> wrote in
message news:D2BAE545-3DFD-4C09-BDB6-97BB27A5110E@microsoft.com...
> Thanks... One problem... Tell me if I am doing this wrong... I went to the
> "control toolbox" and clicked "design" and dragged a "control button" to
the
> sheet.. doubleclicked the button to get to the Visual Basic and copied and
> pasted the formula into the Private Sub CommandButton1_Click ()... I
changed
> the "sourcesheet" to "sheet1" because that is where I am going to have the
> button, but what do I need to change the "destinationsheet".range("a1) to?
> Thanks again.. This is new to me..
>
> "Don Guillett" wrote:
>
> > sheets("sourcesheet").range("a2:x200").copy
> > sheets("destinationsheet").range("a1")
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "Jalifid@hotmail.com" <Jalifid@hotmail.com@discussions.microsoft.com>
wrote
> > in message news:ACF32CF2-5218-46B9-B5D7-95112FCF06B4@microsoft.com...
> > > I am making an excel spreadsheet and I want to create a command button
on
> > the
> > > sheet itself to where a user can go to another area, copy materal,
come
> > back
> > > to the worksheet and click on the command button to paste information
onto
> > > the sheet to a specific cell without using keyboard shortcuts or the
> > mouse..
> > > Is this possible and how?
> >
> >
> >