Find loop

J

Jamie

On a sheet called orderdata i have values indexed by there order id this is
in a form of 10001 or 10002 etc. I need a way of going through each row with
the same order id as im displaying them on a invoice. An example of the data
on the sheet is

ID , Description, quantity

10001, An example, 2
10001, An example2, 3
10002,... etc

For each row i need to find out the row that the data is on so i can gain
the decription and quantity from the script.

Thanks for any help

Jamie
 
C

chris

Trry this
Set c = MyRange.Find(Val
If Not c Is Nothing The
firstAddress = c.Addres
D
Set c = MyRange.FindNext(c
Rw=range(c.address).ro
Loop While Not c Is Nothing And c.Address <> firstAddres
End I


----- Jamie wrote: ----

On a sheet called orderdata i have values indexed by there order id this i
in a form of 10001 or 10002 etc. I need a way of going through each row wit
the same order id as im displaying them on a invoice. An example of the dat
on the sheet i

ID , Description, quantit

10001, An example,
10001, An example2,
10002,... et

For each row i need to find out the row that the data is on so i can gai
the decription and quantity from the script

Thanks for any hel

Jami
 
Top