software

Hello,

This first chart is where I am entering names by day (sheet one). Please
notice that not all fields are filled in (this will vary by day).

Name 1Name 2Name 3Name 4
1/1/2006
1/2/2006
1/3/2006
1/4/2006
1/5/2006SmithJonesCooper
1/6/2006SmithJones
1/7/2006JonesCooper
1/8/2006
1/9/2006JonesCooper
1/10/2006
1/11/2006Jones
1/12/2006SmithJonesCooperSmith
1/13/2006Jones
1/14/2006CooperSmith
1/15/2006SmithJonesCooperSmith
1/16/2006

What I need help with is writing a formula that will bring the names from
sheet 1 into a table I will keep on sheet 2. The names need to come over by
weekending: for example in the chart below I need to have the names listed on
1/15 first, then the 14th, 13th and so on all the way to the 9th. There
could be as many as 20 names per day (line), and I also need help getting
past hte null cells. Sheet two will have a start and end date listed on the
page.

Week ending: January 15, 2006
SmithJonesCooper
SmithCooperSmith
JonesSmithJones

Thanks