Formula help for multiple worksheets
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?
|