Formula help for multiple worksheets
I understand how to get the data from one worksheet to another but the
proplem is I am trying to formulate the data the other sheet will bring over
from the formula I listed.
"Ben" wrote:
the easiest way to do what you want is todo the following:
in the cell that you want to copy the data into place an eaquals sign...then
go to the worksheet that has the data you want to replicat and click on the
cell that has the data. That's it...you can then drag down using the small
black plus sign (bottom right corner of the cell) to copy the formula down.
"Jeremy" wrote:
I have 2 worksheets one is named cons and the other rep. I am trying to
get the data from the rep to cons using a formula written like
=SUMIF(B1:B4,"Jane Doe",C1:C4). The formula is for data in the rep
worksheet. How would I tell it to pull the data from the rep worksheet?
|