REFERING TO CELL IN DIFFERENT SHEET

  • Thread starter Thread starter cjbarron5
  • Start date Start date
C

cjbarron5

HOW DO YOU REFER TO A CELL IN A DIFFERENT SHEET? I WOULD LIKE SOMETHING LIKE
=LABOR!A1 BUT IT DOESNT WORK
 
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 said:
HOW DO YOU REFER TO A CELL IN A DIFFERENT SHEET? I WOULD LIKE SOMETHING
LIKE
=LABOR!A1 BUT IT DOESNT WORK
Click to expand...
=Sheet6!A1
 
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
 
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

Code to format cells on several worksheets 2
Reference a fixed cell on different sheets 4
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Formula involving different sheets 1
Cell Reference on a different sheet 3
vlookup and hlookup in the same formula 6
linking two cells that are bi-directional 2
Duplicate "Drag" feature 2

Back
Top