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

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

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