Azrael;3236560 Wrote:
Kind of helpful, but this is what I have made so far and would like the
data from cell J5 to post to cells c91 for the first survey, c92 for
the second all the way to c100.

Don't want to start from scratch if I can help it.

Thanks for the help.

Dave

OK,I've done some work, and changed where the data needs to be posted
to, and this is what I have so far:
Range("J5:J45").Select
Selection.Copy
Sheets("Data_Summary").Select
Range("B4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=True

What I need is for this to paste the selected data to Row B5 the next
time that the macro is run then B6 etc adding a line every time that
the macro is run.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Azrael