How to create a Loop

**Sahak** · 10-08-2008, 11:58 AM

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** · 10-08-2008, 12:51 PM

Instead of Loop use a For Each function.

Please Login or Register  to view this content.

Success

**Sahak** · 10-08-2008, 01:53 PM

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** · 10-08-2008, 02:44 PM

Some thing like this,

Please Login or Register  to view this content.

**Sahak** · 10-08-2008, 02:49 PM

Hi Andy,

Thank you very much. It works perfect

How to create a Loop

LinkBack

Thread Tools

Rate This Thread

Display

How to create a Loop

help with Loop

Loop

Thread Information

Users Browsing this Thread

Similar Threads

Create new workbooks and worksheets from an existing Workbook

Programming a Find Loop?

Do Loop Until Loop

For type loop verse Do type loop

Extend Loop From Within ?

Bookmarks

Bookmarks

Posting Permissions