Copy/Paste(transpose/values) into a new sheet in a new row

[jennybean]

Hello


I am trying to do the following in my excel work book.


I would like to copy cells "E5,E7,E9,E11,E13,E15,E17,E19,E21" from sheet "Form" to a table in sheet "Data Collection". I have built a Macros that copies the cells and transposes and pastes the values into A2 on sheet "Data Collection" but I am unsure how to start a new row.


If I wasnt clear enough in the instructions, please let me know and I will add more detail.


Thank you

 

[Luke M]

Perhaps something like:

[pre]

Dim DestCell as Range
Set DestCell = Worksheets("Data Collection").Range("A2").End(xlsDown).Offset(1,0)

[/pre]
and then paste into DestCell using whatever method works best for you.