using multiple sheets from a workbook in a formula

M

Megglesface

If I want to use a cell value in a formula, but the cell is from another
worksheet in the same book, how do I do this? I thought I just entered = into
the formula box then clicked onto the other worksheet and selected the cell,
but that doesnt seem to be working, any ideas anyone?

Thanks.
 
M

Megglesface

well if the cell I want the formula in is A1 on sheet2, and the cell I want
to use as part of my formula is B1 on sheet1, then how can i make this into a
formula? If I click on B1 then it brings up the wrong cell reference in my
formula field.
 
G

Gord Dibben

Type the = sign, switch to other sheet, select a cell then hit ENTER key.


Gord Dibben MS Excel MVP
 

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

Autonumber field in Excel that behaves the same as Access 0
Use & with two formulas 2
Multiply with Vlookup value from another Worksheet 0
Excel Formula question 0
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Cells not updated automatically 3
move a row of data from one work sheet to another using a formula 1

Top