Excel and adding cells items...

  • Thread starter Thread starter Ivan T. Williams
  • Start date Start date
I

Ivan T. Williams

Does anyone know how to add an item from a cell on sheet 1 to a cell on
sheet 2?
 
if the formula cell is on sheet2.

='sheet1'!a1+b99
(b99 is on sheet2, so it doesn't need the sheet name in front of it.)
 
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

If question 3
Excel, assign cells in multiple worksheets from one sheet 1
Figuring out a lengthy formula. Probably quite simple... 3
is this possible in excel 2007 3
Imbedded Data Input sheet 3
Using Excel to Separate info within a Cell 3
CONDITIONAL FORMATTING BETWEEN SHEETS 1
same formula and cells for different worksheets 1

Back
Top