Copy Certain cells on a row and paste into a comment

Are Reference Number, Customer Name etc definitely going down the column, ie A1, A2, A3 etc?

Or are they going across the row, eg A1, B1, C1 etc?

Try this.

Please Login or Register  to view this content.

Hello Norie

Thankyou! this works perfectly, I appreciate you taking your time out to help me.

I wonder if you would be able to help me a little bit more.

The code works perfectly however I would like to Copy the header as well for example:-


A1: Reference Number B1: Customer Name: C1: Payment Data D1: Renewal Date E1: Contact Number: F1: Model of Car


A2: A95124D B2: Kirsty Lenton C2: 54553453 D2: 10/10/2015 E2: 801 34356 3453 F2: Pontiac


A3: B34354F B3: Timothy Jones C3: 23433545 D3: 01/01/2014 E3: 234546 F3: Dodge

So the comment in A2 would say:

Reference Number: A95124D
Customer Name: Kirsty Lenton
Payment Data: 54553453
Renewal Date: 10/10/2015
Contact Number: 801 34356 3453
Model Of Car: Pontiac

So the comment in A3 would say:

Reference Number: B34354F
Customer Name: Timothy Jones
Payment Data: 23433545
Renewal Date: 01/01/2014
Contact Number: 234546
Model Of Car: Dodge


Also is there a way to re-size the comment box so all the data fits in??

Thanks