In coloumn B, insert the following formula, then copy it across to col AV.
The ",2" must change for every column to the right, ie C=3, D=4 etc
=IF($A1="","",VLOOKUP($A1,Sheet1!A1:AV365,2,FALSE) )

"MRG Perez" wrote:

In a WorkSheet, I have Sheet 1= 365 rows with column a = date 1/1/06 thru
12/31/06 and in columns b thru av infomation about that date.

In Sheet 2 I would like to insert a date in cell 1 that would equal one of
the dates that are in sheet 1 and have excel copy to sheet 2 everything
related to that row from sheet 1.

Can someone tell me what formula should I create?
--
Museum Restaurant Group