Copy cell to another that is blank
 

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

Copy cell to another that is blank
 

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!



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Mickey" wrote:

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

Copy cell to another that is blank
 

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


"Wigi" wrote in message
...
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!



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Mickey" wrote:

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

Copy cell to another that is blank
 

Select column A and F5SpecialBlanksOK

Type an = sign in active cell.

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


Gord Dibben MS Excel MVP


On Sat, 14 Jul 2007 19:08:34 +0100, "Mickey" wrote:

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


"Wigi" wrote in message
...
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!



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Mickey" wrote:

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

Copy cell to another that is blank
 

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

F5SpecialBlanksOK

Thanks for catching Gord.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Gord Dibben" wrote:

Select column A and F5SpecialBlanksOK

Type an = sign in active cell.

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


Gord Dibben MS Excel MVP


On Sat, 14 Jul 2007 19:08:34 +0100, "Mickey" wrote:

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


"Wigi" wrote in message
...
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!



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Mickey" wrote:

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

Copy cell to another that is blank
 

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

Thank You,
Mickey