Hi,

I am slightly familiar with excel, macros and visual basic but would
really like a quick fix for this problem. I want to take a range of
cells that look like this:

Ex.1 Ex.2 Ex.3
2007-02-09 1 4 1
2007-02-10 3 3 3
2007-02-11 5 2 4
2007-02-12 4 7 7
2007-02-13 7 9 5
2007-02-14 3 8 9
2007-02-15 2 6 8

I then want to be able to take the first row (i.e. 1,4,1) and copy it
to the next sheet in my workbook but values only and transposed, which
ive already figured out as:

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=True

In the same macro i then want to take the second row (3,3,3) and copy
it to the sheet after the one I just pasted to and carry on down the
list until I hit blank.

Any ideas?


Help much appreciated :)