3D reference

Hi!

How do I get excel to copy specific cells in a different worksheet when I drag/copy?
I need f.x. sheet3!A1 copied to sheet1!A1, but then i use sheet1 a2,a3,a4,a5,a6 to calc. Then I need sheet3!A2 copied into sheet1!a7 and then again i use 5 cells down to calc, but then when i drag it should go like that, but it takes sheet3!A8 instead of A3 because I wnet down 5 cells in sheet1...

How can I make it easy and fast so I can just drag it down?

Thanks

okay, i'll try and show it

SHEET1-----------------------------SHEET2------------------------------SHEET3
----a------------b---c----d-----------a---b---c----d-----------------------a b c d
1 sheet3!A1---------------------------------------------------------------(some numbers)
2 a1/434
3 a2+763
7 sheet3!A2
8 a7/434
9 a8+763
13 (here would i like to drag the list down and copy the work i've done, but with sheet3!A3 etc, but it changes to sheet3!A8 because i go 5 down ind sheet1, it also goes 5 down in sheet3, but i only want it to go down by 1..)

Hope it clearyfied my problem

I am btw from Denmark, so my apolegize for bad spelling/gramma..

Originally Posted by OllyXLS

And, again, learn the difference between A7 and $A$7...

This might help the OP to understand the differences: http://www.dummies.com/how-to/conten...-excel-21.html