Hi All,

Can anyone offer any assistance here.

If I copy a file from Word and paste it into excel, the information, instead of going accross the page, stays in column A and goes all the way down, missing a row between each piece of info.

I have a huge amount of report/pastes like this to do and thought I could build a macro to sort into a predefined format, saving me weeks of manual typing, formating, and repetitive strain injury.

I have a very small example I could send.

Regards