HOW DO I program one worksheet to get info from another?
 

I am trying to setup a worksheet that grabs information from cells on another
worksheet. I have set up two worksheets that keep track of different
information. I want to transfer information from one cell in worksheet one to
another cell in worksheet two...and I can't seem to figure it out...

HOW DO I program one worksheet to get info from another?
 

One way:

Use Copy and Paste Special | Paste Link

Regards

Trevor


"kenny" wrote in message
...
I am trying to setup a worksheet that grabs information from cells on
another
worksheet. I have set up two worksheets that keep track of different
information. I want to transfer information from one cell in worksheet one
to
another cell in worksheet two...and I can't seem to figure it out...

HOW DO I program one worksheet to get info from another?
 

You can put the sheet name in a formula to refer to another
sheet. For example, in A1 on sheet1, use

=Sheet2!A1

to return the contents of A1 on sheet2.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"kenny" wrote in message
...
I am trying to setup a worksheet that grabs information from
cells on another
worksheet. I have set up two worksheets that keep track of
different
information. I want to transfer information from one cell in
worksheet one to
another cell in worksheet two...and I can't seem to figure it
out...

HOW DO I program one worksheet to get info from another?
 

I can't figure out what the formula is....

"Chip Pearson" wrote:

You can put the sheet name in a formula to refer to another
sheet. For example, in A1 on sheet1, use

=Sheet2!A1

to return the contents of A1 on sheet2.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"kenny" wrote in message
...
I am trying to setup a worksheet that grabs information from
cells on another
worksheet. I have set up two worksheets that keep track of
different
information. I want to transfer information from one cell in
worksheet one to
another cell in worksheet two...and I can't seem to figure it
out...

HOW DO I program one worksheet to get info from another?
 

go to the destination sheet.

click in the cell where you want the results

type and equal sign (=)

no go to the source cell in the other worksheet and click in it.

hit the return key

the formula should be entered for you.

--
Regards,
Tom Ogilvy


"kenny" wrote in message
...
I can't figure out what the formula is....

"Chip Pearson" wrote:

You can put the sheet name in a formula to refer to another
sheet. For example, in A1 on sheet1, use

=Sheet2!A1

to return the contents of A1 on sheet2.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"kenny" wrote in message
...
I am trying to setup a worksheet that grabs information from
cells on another
worksheet. I have set up two worksheets that keep track of
different
information. I want to transfer information from one cell in
worksheet one to
another cell in worksheet two...and I can't seem to figure it
out...