Reggiee,

You're welcome.

Blanks are OK in your data, as long as there are no fully blank lines, and none at the bottom on
column A. Since Column A is, presumably, your identifiers, it should be fully filled in.

HTH,
Bernie
MS Excel MVP


"Reggiee" wrote in message
...
thanks Bernie

Quite neat that - I think the workbooks may have some empty cells in there
but am sure i can add some code to delete these cells

Thanks again