For Each Loop

[oakman]

Greetings to all, I am fairly new to VB code. I have a running log for everyday. I have a list of about 200 items in a drop down list in column F. On each row I make an entry by picking an item from the dropdown list depending on a particular set of circumstances. During the day, I could have several different items(one per row) or the same item repeated several times (one entry per row). What I am trying to do is to create a report that looks at a certain date range, will reference the item list and find each instance that the item appears. For example, I would like to look at Saturday and find each time that peaches was selected from the dropdown on column F, in addition, I would like to copy the data in column A, B, and D from each entry that has peaches on Saturday on to a separate sheet that will summarize the data. I would like to repeat this process for each of the 200 items on the list. Is this possible? I was thinking of using an ForEach Loop but not sure how to approach it. Any advice is greatly appreciated! Thank you

[fomoz]

i think this sounds like something you should do with a pivot table.