Return an entire row of data from a Date

Hi Guys,

Im looking at making a register for my kennel business.

I will basically have a database of all the dogs that have been and are to be checking in, This is the first sheet.

Sheet 2 ,I then basically am trying to add little drop down box that allows me to choose a date and return all the dogs that are currently here (according to date) and any that are booked in after the date.

I have had a go using the vlookup and the index functions but i am a bit past with all the techno lingo and would greatly appreciate any help. If the drop down box or calendar selction method on sheet 2 isn't feasable, is it possible to have a =Today() function which automatically returns all the dogs in from todays date and onwards???

I had a go at some formulas but thought best to take them out of the workbook so as not to confuse anything.

Cheers guys

It is much simplier to use Filter or Advanced Filter, why not? Or it is necessary to get data to Sheet2?

Thanks guys,

hohlick i did think that but i need multiple dates to show? from the date selected onwards

Daffodil thank you for the quick response, thats great, just one thing; i wanted it to show from the date chosen onwards, not backwards. Not sure if this is a simple remedy.

eg. 09/09/14 chosen

09/09/14
10/09/14
11/09/14

to appear not before 09.

Thanks again

Sorry yes, dogs that are currently in and all future bookings