How to create a Loop

[Sahak]

Hi All,

I’m getting data from query. My data has fields: Item No, Customer ID & Sales rep.
I need to find out for each Item number which customer put order and who was the sales rep. (Excel 2002)
Please see file attached.

Thank you in advance.

[WinteE]

Instead of Loop use a For Each function.

Please Login or Register  to view this content.

Success

[Sahak]

Hi WinteE

Thank you very much for reply.
I’m sorry for not understanding. Please make clear what should be instead of “Whatever” & what to do after “Then …..”

Thanks again

[Andy Pope]

Some thing like this,

Please Login or Register  to view this content.

[Sahak]

Hi Andy,

Thank you very much. It works perfect