LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 125
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to select a specific range based on the time value of user form input Jitranijam New Users to Excel 8 November 15th 06 12:52 AM
Generating dynamic charts based on the user input shivan4u Charts and Charting in Excel 4 February 13th 06 12:43 PM
Message Input with link to different work sheet KPM New Users to Excel 0 February 4th 06 05:20 PM
Copy an additional row based on another sheet Mindie Excel Discussion (Misc queries) 5 October 19th 05 02:47 AM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 06:52 PM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"