Need macro to post data from user input
 

I am building a survey and need a macro, so as to post the data inputed
to another area of the sheet/workbook and maintain a consecutive
listing of the data inputed.

ie survey question 1 ____, q2_____


Posts to data area:
survey 1 question 1 ____, q2 _____
survey 2 question 1 ____, q2 _____

I can send/upload the file if that would help.

Thanks in advance




--
Azrael

Need macro to post data from user input
 

See the attachment....


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com


+-------------------------------------------------------------------+
|Filename: Form.zip |
|Download: http://www.officefrustration.com/attachment.php?attachmentid=821|
+-------------------------------------------------------------------+



--
Chris Bode

Need macro to post data from user input
 

Chris Bode;3236559 Wrote:
See the attachment....


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

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


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



--
Azrael

Need macro to post data from user input
 

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