Help with Double Loop

To whom it concerns

I require some guidance around double loops I require an example of code
which performs the following task on work sheet1

r = 1

Does until cells(r,1) = End Report
r = r +1
The performs a control find command which looks for
A field called "name" and paste it onto cells(a4) sheet2
A field called "Address 1" and paste it onto cells (b4) sheet2
etc
etc
The loop then runs again pasting 1 row down see below
A field called "name" and paste it onto cells(a5) sheet2
A field called "Address 1" and paste it onto cells (b5) sheet2

Thank you in anticipation

Marcus

David
Tue Feb 13 08:43:33 CST 2007

Try the Excel newsgroup. This one is for FrontPage.


"Marcu2" <Marcu2@discussions.microsoft.com> wrote in message
news:B8D3181A-C90A-41F5-87DC-53BB6268348C@microsoft.com...
> To whom it concerns
>
> I require some guidance around double loops I require an example of code
> which performs the following task on work sheet1
>
> r = 1
>
> Does until cells(r,1) = End Report
> r = r +1
> The performs a control find command which looks for
> A field called "name" and paste it onto cells(a4) sheet2
> A field called "Address 1" and paste it onto cells (b4) sheet2
> etc
> etc
> The loop then runs again pasting 1 row down see below
> A field called "name" and paste it onto cells(a5) sheet2
> A field called "Address 1" and paste it onto cells (b5) sheet2
>
> Thank you in anticipation
>
> Marcus