I have a workbook with the two sheets.

Sheet 1 contains in Column A various categories and the next 31 column
headings represent a date (day for each day of the month) the dollar
amount associated with each category by day.

Sheet 2 contains in column A some of the various categories from Sheet
1 and in Sheet2!B1, I would like to insert the date and it would
automatically populate the corresponding values from Sheet 1 for each
category listed on Sheet 2 for the filled in date.

Not sure the best way to do this.....

Thx!!