Combining data from multiple worksheets and separate spreadsheets

K

kfletchb

How do I take data from one worksheet and perform formulas with data on
another worksheet? How do I do this with separate spreadsheets? Mahalo.
Karen
 
R

raypayette

In the resulting worksheet insert an equal sign and select another
worksheet, it will provide a formula similar to:
=Sheet2!D4
 
Top