Excel Question
Thread Starter
Senior Member
Joined: Mar 2002
Posts: 16,353
Likes: 0
From: Ossining, New York
Originally Posted by Grifter
are you using a formula?
as in
as in
Code:
=a1+a2
Here are two examples of what I am doing.
One instance I am using a value which is the customer name. It is on the first sheet with the customer address and such. The last sheet is a letter that goes to the customer. I need to take the customer name from the 1st sheet and apply it to the last sheet's letter.
A second example is taking a value from a chart on the second tab and plugging that value into a forumula within the 3rd tab.
snitches get stitches
Joined: May 2002
Posts: 49,696
Likes: 1
From: Portland, OR
k...here's how to do it:
in the cell you want the info displayed, you have to type =[sheet1!]$A$1
replace "sheet1" with the tab you are drawing your info from, make sure to include the !, also don't use the [ ], and replace A1 with the cell number its coming from on the first sheet.
so for example I want to draw the info from cell C7 from the "Assumptions" tab, it'll look like this:
=Assumptions!$C$7
in the cell you want the info displayed, you have to type =[sheet1!]$A$1
replace "sheet1" with the tab you are drawing your info from, make sure to include the !, also don't use the [ ], and replace A1 with the cell number its coming from on the first sheet.
so for example I want to draw the info from cell C7 from the "Assumptions" tab, it'll look like this:
=Assumptions!$C$7
Thread Starter
Senior Member
Joined: Mar 2002
Posts: 16,353
Likes: 0
From: Ossining, New York
Originally Posted by RB
k...here's how to do it:
in the cell you want the info displayed, you have to type =[sheet1!]$A$1
replace "sheet1" with the tab you are drawing your info from, make sure to include the !, also don't use the [ ], and replace A1 with the cell number its coming from on the first sheet.
so for example I want to draw the info from cell C7 from the "Assumptions" tab, it'll look like this:
=Assumptions!$C$7
in the cell you want the info displayed, you have to type =[sheet1!]$A$1
replace "sheet1" with the tab you are drawing your info from, make sure to include the !, also don't use the [ ], and replace A1 with the cell number its coming from on the first sheet.
so for example I want to draw the info from cell C7 from the "Assumptions" tab, it'll look like this:
=Assumptions!$C$7