Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

http://i.stack.imgur.com/tOB2t.gif

Can I reference a cell in another worksheet like this?

Example:

Worksheet A
A1 Data1
A2 
A3 Data2
A4 
A5 Data3

Worksheet B (I want to copy by referencing the cells in Worksheet A)

B1 'Worksheet A'!A1
B2 'Worksheet A'!(A1+2) ~ meaning I want to copy cell 'Worksheet A'!A3
B3 'Worksheet A'!(A3+2) ~ meaning I want to copy cell 'Worksheet A'!A5 ... Note that A3 in this formula comes from the formula in B2 by skipping one row in Worksheet A.
B4 'Worksheet A'!(A5+2)

The reason for this is so that I can skip the A2 and A4 cells and be able to drag the formula in Worksheet B to extend it without the need to point manually each cell that I want to copy from Worksheet A.

share|improve this question
    
Whoa... Detailing your explanation would be good. All I can say, quickly like that, is that you can very well, when you're allowed to select your data with your mouse, click another worksheet and select data from there. The code generated should guide you. –  Ariane Aug 22 '13 at 20:09
add comment

1 Answer

You can probably put the headers easily, but the data, you can use this for the first column:

=INDEX(Sheet5!$A:$A,(ROW()-1)*4-1)

This one for the second:

=INDEX(Sheet5!$A:$A,(ROW()-1)*4)

This one for the third:

=INDEX(Sheet5!$A:$A,(ROW()-1)*4+1)

If it weren't for the picture, I would have given up trying to understand you! xD

+1 for this :)

share|improve this answer
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.