Can I enter a formula using data from cells in seprate worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take the results of a fromula on one sheet and use it on another
sheet. I want to know if I can put a formula in that can draw information
from cells in a different worksheet.
 
I want to take the results of a fromula on one sheet and use it on another
sheet. I want to know if I can put a formula in that can draw information
from cells in a different worksheet.
Click to expand...

Could it be as simple as?
=Sheet2!A1, which returns the value in A1 on sheet2.

Per Erik
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use a worksheet name in a formula? 4
Worksheet linking 2
sheet name in workshhetfunction 2
Use Formula from another worksheet 3
using the =page! feature to transpose a row to column 0
Creating a template that I can reproduce every month by keying ininformation from SAP 8
move a row of data from one work sheet to another using a formula 1
The blank cells i need to count have formilas in 2

Back
Top