Macro Copy Paste specific cells

Hi All,

You've all been most helpful in the past...

I am running a macro in a 'Host' workbook. I am copying data from a 'Source' workbook.

The macro opens the latest workbook in a folder (source) and copy data back across to the host before closing the source book.

I am only copying A:A from the source book and the numerical data is all either 7 digits or lower.

I only want to copy cells which are less than 7 digits and paste them neatly back into the host worksheet. I'm nearly there but I'm stuck on the code to do it slickly.

Can anyone help possibly?

Many thanks in advance!

Guy

How about posting your code here so we can see it, and also a sample spreadsheet