Copying data from vertical to horizontal & keep cell reference

[heatherfeather]

I am trying to copy data from another worksheet and keep the cell reference (data will change). The data is vertical and I need to copy horizontal. I'm looking for an easy way without have to type the cell reference 2000 times.

[MarvinP]

Hi heatherfeather,

I'm afraid that copy and paste special of transpose doesn't work, if I understand your question.

If your formulas were based on named ranges then a copy and paste from vertical to horizontal may work.

If you give us a sample workbook it would be easier to understand the question and be more sure of an answer.

[DonkeyOte]

heatherfeather, you should find you can use INDEX

Please Login or Register  to view this content.

So Sheet2!A1 = Sheet1!A1, Sheet2!B1 = Sheet1!A2, Sheet2!C1 = Sheet1!A3 etc...

You could also look at OFFSET but personally I prefer the above.