Hi,

I'm stuck.

I've created a spreadsheet for work, that is based on data entered into rows along the worksheet (Sheet1), but I'm wanting to make a summary sheet with the same data from the first sheet, on the second, but this time the vertical data needs to be horizontal (e.g. Sheet1, Cell A15, needs to go onto Sheet2, Cell D4 & Sheet1, Cell A20 needs to go onto sheet2, Cell D5 etc. etc).

So far, I've been manually "autofilling" the cells in Sheet2 (by using the formula function and deleting the =), then dragging them around the sheet into position. There must be an easier way of doing this!

I've looked at OFFSET, but my problem is the data starts at A15, and continues every 5th row down the sheet, and for the life of me I can't figure out where I'm going wrong, as every way I try I get #REF! or #VALUE!.

Anyone tried the same and got an answer? There could be a beer in it for someone.....!