Creating Macro: want it to only use data newly added row in second sheet

[CharlieParlie]

Hi all,

My first day on the forum, actually my first day trying out macro and already facing big unsolvable problems.. So, this is up:

I'm working with two excel sheets. The first sheets get's its data straight out of SurveyMonkey, what means that every row contains all the responses of the person who filled in the survey. Every colum contains an answer to the questions asked in the survey. In the second sheet I select the row in the first sheet and paste in the second by option 'Paste special --> transpose'. So you get every answer from one respondent directly underneath each other. Now I have to do it with every respondent again, it takes a lot of time. Because the survey is open for like six weeks, new respondents will be added in rows every day (how to get automatic macro)


So what I want is to be able to select any row in the first sheet and in the second row it will show the correct info (transposed), and I dont want to create a Macro for every row in the first sheet, if u know what I mean.

How can I do that, because the macro had to get a different row everytime? Now it only works for one row and i get the same thing in the second sheet every time.


PS dont know if this post is correctly explaining the problem but don't know how to better explain. Thank you in advance for your help!

[Bernie Deitrick]

In the second sheet, enter this in cell A1:

=INDEX(Sheet1!$A:$Z,COLUMN(),ROW())

(with whatever your sheet name actually is:

and then copy down for as many rows as you have columns, then across for many more columns than you have rows...