Split the Pasted Data

[JonesZoid]

Reference to my last post

http://www.excelforum.com/excel-prog...-workbook.html

The data is being passed ok now and all is good apart from 1 minor detail.

How can i split the data?

The data is pasted across 1 row matching the ID Field in column A.
Can i paste the data in - leaving a gap between the ID Field and the other data being pasted - 5 columns to the right would be ok.

Attachment 283447

Here is the code upto know:

Please Login or Register  to view this content.

[JonesZoid]

The above code - pastes all the data including the ID field from column 25.
Whereas i would like the ID field to stay in column 1 and then the rest of the data be pasted from column 25 onwards.