| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REFERING TO CELL IN DIFFERENT SHEET
HOW DO YOU REFER TO A CELL IN A DIFFERENT SHEET? I WOULD LIKE SOMETHING LIKE
=LABOR!A1 BUT IT DOESNT WORK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REFERING TO CELL IN DIFFERENT SHEET
Hi CJ,
The syntax would be similar yo: =Sheet6!A1 However, the simple solution is to type the equals sign (=) into the cell of interest, select the A1 cell on your Labor sheet and hit Enter; Excel will automatically imsert the requisite formula. --- Regards. Norman "cjbarron5" wrote in message ... HOW DO YOU REFER TO A CELL IN A DIFFERENT SHEET? I WOULD LIKE SOMETHING LIKE =LABOR!A1 BUT IT DOESNT WORK =Sheet6!A1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REFERING TO CELL IN DIFFERENT SHEET
thanks the first time I typed it it didnt work but I knew it was right then after I posted I got it to work THANKS "Norman Jones" wrote: Hi CJ, The syntax would be similar yo: =Sheet6!A1 However, the simple solution is to type the equals sign (=) into the cell of interest, select the A1 cell on your Labor sheet and hit Enter; Excel will automatically imsert the requisite formula. --- Regards. Norman "cjbarron5" wrote in message ... HOW DO YOU REFER TO A CELL IN A DIFFERENT SHEET? I WOULD LIKE SOMETHING LIKE =LABOR!A1 BUT IT DOESNT WORK =Sheet6!A1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function refering sheet index. | Excel Worksheet Functions | |||
| Refering a cell | Excel Worksheet Functions | |||
| Refering to an empty cell | Excel Discussion (Misc queries) | |||
| refering to previous sheet | Excel Discussion (Misc queries) | |||
| Refering to a tab using data from a cell | Excel Worksheet Functions | |||
Linear Mode
