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

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

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

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

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

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

Thank You,
Mickey