| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook?
That helped me out thanks!
Bernard Liengme wrote: Do you mean something like =2*Sheet1!A1 ? This returns twice the value of Sheet1's cell A1 You can type as shown or: type =2*, open Sheet1 by clicking its tab and click the cell A1 either continue typing, or click the green check mark or use ENTER to finish the formula Not that is the sheet's name has a space in it, then it appears as 'January data'! with single quotes around the name (not the explaination mark!) Does this answer your question? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Lexi" wrote in message ps.com... How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
