auto fill from a column to a row in a different worksheet

[knesl69]

I have a column A

1

2

2

3


How do a drag across a column (formula) which is copied and pasted into another worksheet then I wish to autocopy across a row


for example this formula =SAStructure!$K4 - when I drag to the right the $k stay still but the row number 4 does not automatically change to k5, k6, k7 etc


thank you Mark

 

[Luke M]

Check this out:

=OFFSET(SAStructure!$K$4,COLUMN(A$1)-1)


As you drag this formula to the right, the COLUMN() function will increment in value, causing the OFFSET function to look farther and farther down (aka, K4+1 = K5, K4+2 = K6, etc)