=HLOOKUP(B$1,Sheet1!B$1:D$5,ROW(),0)

HTH
--
AP

"ashish128" a écrit dans le message de
oups.com...
Hi Everyone, I have two sheets in my excel file. First Sheet goes like
this
1/1/2006 1/2/2006 1/3/2006
Bill 10 30 50
Harry 20 40 60
Sam 30 50 70
Joshua 40 60 80

Second Sheet has formating like

Day <user will give input here in form of date OR the macro will ask
Bill <value of bill for that date
Harry <value of Harry for that date
Sam <value of Sam for that date
Joshua <value of Joshua for that date

Is there any formula or macro which will ask me for a date and will
insert the required values in sheet 2