Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I can just do B12 to reference a field on the same sheet I'm working on, but how do I reference B12 on another sheet?

share|improve this question
    
Try asking on webapps.stackexchange.com (or wait until this question is closed and migrated there) –  Doug Harris Dec 13 '10 at 16:01
add comment

migrated from superuser.com Dec 14 '10 at 6:44

This question came from our site for computer enthusiasts and power users.

1 Answer

up vote 4 down vote accepted

It's the same way as Excel would -

=SheetName!CellNumber

If your sheet name contains spaces, wrap the name in single quotes.

='Sheet Name'!CellNumber
share|improve this answer
    
I'd select you as the answer, but it won't let me since I just created my account here.... –  Webnet Dec 14 '10 at 19:28
    
@Webnet drop in here ( chat.stackexchange.com/rooms/7 ) & request @rchern for a merge in accounts :) –  Sathya Dec 14 '10 at 20:06
    
What if there's a space in the sheet name? –  Webnet Feb 22 '11 at 3:17
    
@Webnet wrap the name in single quotes. ='Sheet Name'!CellNumber –  Sathya Feb 22 '11 at 4:28
    
What if I want to reference it by a formula? –  kappa Dec 7 '12 at 9:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.