Thread
:
Help with double loop
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Help with double loop
And where might we expect to find "name" and "Address 1"
--
Don Guillett
SalesAid Software
"Marcu2" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett