command button to copy cells from one worksheet and insert to another

hello,

I'm very new to macros and need help creating a macro with a command button that will copy info from cells on a worksheet template and insert them into another worksheet transposed on. this form would be used on an on going basis so it would also have to save the current info and insert a new row every time the button was clicked. Any help would be greatly appreciated. I have included the file for reference
thanks
eric

Basically you'd use the row # in the template sheet as the column # in the Contact List. You'd have a do loop that reads down the template sheet (to the last data field) and as you go you'd "write" the data to the Contact List.
However to make this work easier (with the code below) you should change your template as follows:
1) just have one column to contain the data
2) Don't span the multi-row data. Just increase the size of the row. Otherwise you have to adjust for all of the rows and will make if very complicated.

Please Login or Register  to view this content.

If this is helps please click on the Add Reputation link.