generate report from date and obtaining all data in row

R

ronbwa

How do I generate a report by typing in a date and retrieve all data in the
row for that date in excel?
 
M

Max

How do I generate a report by typing in a date and retrieve all data in
the
row for that date in excel?
Click to expand...

Assuming date data is in col B (say),
apply autofilter on col B by selecting entire col B,
then click Data>Filter>Autofilter,
and you can then click on the droplist in B1 for options
 
Top