Copy cell to another that is blank

[Mickey]

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

 

[Guest]

Hi Mickey

You don't need VBA for this. Here you go:

Select the whole column of numbers, including blank cells, beginning in A4

In A4, type:

=A3

Hit Ctrl-Enter, not just Enter.

Then, copy the whole range (just leave it selected as it was), and using
Edit > Paste Special > Values, you change the formulas into hard values.
You're done!

 

[Mickey]

Hi Wigi,
That appears to just place the value of A3 into every cell, I need it to
recognise that there is a value in a cell, say A15 and then start
replicating the new value.

Thanks,
Mickey

 

[Gord Dibben]

Select column A and F5>Special>Blanks>OK

Type an = sign in active cell.

Click on or arrow up to cell above then hit CTRL + ENTER.


Gord Dibben MS Excel MVP

 

[Guest]

Indeed, sorry, I forgot to mention the SpecialCells part:

F5>Special>Blanks>OK

Thanks for catching Gord.

 

[Mickey]

That's fantastic,
Many thanks to both of you for your help, this will save me lots of time.

Thank You,
Mickey