Linking worksheets

  • Thread starter Central Station Manager
  • Start date
C

Central Station Manager

I have limited knowledge of formulas. I am trying to subtract totals on
worksheet 1 from total on worksheet 2.
 
K

Kaman

Simple..in your destination cell where you want the answer to show up, simply
type "=" (w/o quote). Then go right over to Worksheet 2 and click the cell
you want to subtract from. Then type "-". Then go over to the Worksheet 1
and click on the cell you want to subtract. After clicking that cell, hit
enter. Bam your done. Then you can study the resulting formula if you want
to learn the syntax.

So in my head I say, starting at where I want the answer displayed,
"equals(=) THIS (click on cell) minus (-) THIS (click on cell). Enter."
 
Top