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" <(E-Mail Removed)> wrote in message
news:0F58212E-69D0-47C2-BE6F-(E-Mail Removed)...
> 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 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


On Sat, 14 Jul 2007 19:08:34 +0100, "Mickey" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>news:0F58212E-69D0-47C2-BE6F-(E-Mail Removed)...
>> 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:

F5>Special>Blanks>OK

Thanks for catching Gord.

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


"Gord Dibben" wrote:

> 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
>
>
> On Sat, 14 Jul 2007 19:08:34 +0100, "Mickey" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
> >news:0F58212E-69D0-47C2-BE6F-(E-Mail Removed)...
> >> 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