Format and Copying troubles

[WadeLair]

SAMPLE GPU.xlsm

I've been attempting to get through this project all day, and I'm really stumped.

I have attached my work so far. I'm trying to use the information on the tab labeled "atlat gpu" to populate a table on the tab labeled "sheet 1."

There are several variables in the file.

The data I really want to know on atlat gpu is the group name, group code and group sold numbers. I need that filled in where there is one row per group name and one column per day in a 14 day period.

The report I'm using to work on my project is a smaller one - there aren't too many groups.

I'm really stumped, and I'd GREATLY appreciate any help.

My project is called Sample GPU.

This is imported as part of a larger process - and I'm open to changing my ways if someone has a better suggestion. I attached two files labeled "Raw" Group Pickup ***.xls. These are the versions of the report I would get, then I need a simple table using some of the information.
Raw Group Pickup JAXPV 03-20-11.xlsRAW Group Pickup RDDRE 06-15-11.xls

The only attributes of the table that are unflexible are - group names/group codes have to be presented in the formatted report in rows, and a 14 day period has to be presented in columns.

The final Attachment 164203Attachment 164202Attachment 164204

[JBeaucaire]

1) Sort the data by date descending.

2) In Sheet1, put this in C1:
=SMALL('atlat gpu'!$C:$C, 1)

3) Put this in D1 and copy to the right:
=INDEX('atlat gpu'!$C:$C, MATCH(C1+1, 'atlat gpu'!$C:$C, -1))

4) Put this in C3, then copy down and across the table:
=IFERROR(INDEX(Group_Sold,MATCH($A3&C$1,INDEX(Group_Code&Arrival_Date,0),0)), "")

[WadeLair]

That's great! Thank you so much for your help. Step 3 really isn't needed, because once the beginning date is determined, the date range is 14 days beginning on that day and moving forward. If I want to populate those in a different way - I don'tt think I'll have any trouble with the rest of it. Thanks so much!

[JBeaucaire]

Step 3 was intended to not list dates that are not in the data.

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.