ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I would like to sort a work sheet based upon user input value,(dat (https://www.excelbanter.com/excel-worksheet-functions/120961-re-i-would-like-sort-work-sheet-based-upon-user-input-value-dat.html)

John Bundy

I would like to sort a work sheet based upon user input value,(dat
 
It sounds like what you want is the AutoFilter
select cell at top of date column
Go to Data-Filter-AutoFilter

click the newly created down arrow and either select a date or go to Custom
and enter beginning and end dates to return. This will return all rows with
dates between your given range.
John

"A1CaddMan" wrote:

I have a spread sheet that keeps track of a bunch of work I am currently doing.
It is also a history of past work, every friday I need to sort the work out
to see whats going on over the weekend.. I am looking for help to do a short
cut that would allow me to enter a date range, then either give me a report
or sort so I could then print..


can anybody help?



All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com