REFERING TO CELL IN DIFFERENT SHEET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cjbarron5 - 28 May 2008 04:13 GMT

HOW DO YOU REFER TO A CELL IN A DIFFERENT SHEET? I WOULD LIKE SOMETHING LIKE
=LABOR!A1 BUT IT DOESNT WORK

Reply to this Message

Norman Jones - 28 May 2008 04:25 GMT

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

> 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 to this Message

cjbarron5 - 28 May 2008 04:32 GMT

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

> Hi CJ,
>
[quoted text clipped - 16 lines]
> > =LABOR!A1 BUT IT DOESNT WORK
> =Sheet6!A1

Reply to this Message