using multiple sheets from a workbook in a formula

  • Thread starter Thread starter Megglesface
  • Start date Start date
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.
 
What do you mean by 'doesnt seem to be working'? what is your formula?
 
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.
 
Perhaps you couldn't read what Gaurav asked:
"what is your formula?"
 
Type the = sign, switch to other sheet, select a cell then hit ENTER key.


Gord Dibben MS Excel MVP
 
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

Excel VBA 1
Can I use a worksheet name in a formula? 4
move a row of data from one work sheet to another using a formula 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Use Formula from another worksheet 3
Use & with two formulas 2
Excel Count If Formula Question 1
I want to add formulas from multiple sheets to master form 1

Back
Top