Return an entire row of data from a Date

[Rkeenan88]

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