Pull data based on date

[culverhr]

I have a complicate problem that hase been beating me for a few days. I don't want to use a macro. I have two sheets in the attached workbook. Sheet 1 is the place where I want all the data populate. It is broken down by days. I want to be able to dump data in the "data" sheet and have it populate the fields, part number, qty, and run time based on the data dump in the data sheet. The problem I have run into is when I do a vlook up it only pulls the first part number based on the date. I want to take the sample data sheet and say for all rows that have a date of 8/22 or 8/23 (these will change), I want it to look in the data sheet and if it finds those dates to populate them under the correct column. That way I won't have to copy and paste so often. I will only change the dates and it will filter the data in the correct columns. The gray columns on the data sheet are the pieces of information I want to pull, you can see the date's on row 3. The yellow on sheet1 is where I would like the respective data populated. Is there anyone who can help??

[NBVC]

in the Data sheet, add a helper column with formula in L2:

Please Login or Register  to view this content.

copied down

Then in the Sheet1 sheet, add a counter for each group. This counts number of matches to the date...

so in say, E2, enter formula:

Please Login or Register  to view this content.

copy E2 and paste to each respective group, e.g. J2, O2, T2, etc...

Then in B5 enter formula:

Please Login or Register  to view this content.

copied down

in C5 enter:

Please Login or Register  to view this content.

copied down

and in D5 enter:

Please Login or Register  to view this content.

copied down

Then copy from B5 to D33 (or whatever bottom cell in column D you have) and paste to each respective group, e.g. G5, L5, Q5, etc...

[culverhr]

Man, you're awesome!!!!! This works perfectly. I have been stumped for days. Thanks