Copy and Paste Loop until end of range

[JamesHampton]

Hi all,

I need help! I have two columns in sheet 2, "Cust Name" in "A" and "Account Number" in "B". I need to somehow get a macro that will copy both cells of this data and paste them into "B1" and "B2" on sheet1, convert the relevant information to PDF (I already have this part of code) and then perform the same action on the next customer and account number, I need to do this to the end of the range in sheet2. Anybody got any ideas? Any help would get my manager off ma back

 

[wesborland1234]

Does it have to be done with a macro? Why don't you just copy the entire range, and then Transpose/Paste it in the new sheet?

 

[JamesHampton]

I have 400 different customers and need to convert the details to PDF but I can only have one customer per page so not able to just paste them all over