generate report from date and obtaining all data in row

  • Thread starter Thread starter ronbwa
  • Start date Start date
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?
 
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

---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting blank rows 4
How To Have A Cell Be Blank If... 2
paste row into Sheet2 in next row 1
Use cell_ref in place of an item in get pivot data function 2
Excel Populate Delivery Note 0
Multiple Sumif conditions 2
Calculating Quarters from Dates 3
My Excel file is not calculating! 13

Back
Top