Hi,
I would appreciate any help with the following - I need to copy the contents
of a cell to another but only if the other cell is blank. The problem is
that we have a row of customer data but each subsequent row does not include
the reference if the folowing order is from the same customer. So, if A3
contains a customer id and rows 3,4,5,6 relate to the same customer, I need
to transfer the contents of cell A3 to A4, A5, A6 but not A7 if that cell
contains another reference number, I then need this to do the same thing
for A7, ie. copy its contents down to the next cell containing a value. I'm
thinking that this could be done via a macro, any help appreciated.

Thanks,
Mickey