I have a speadsheet that has 5 columns. (Headings are in row 2 and are: Cell A2=Date, B2=Name, C2=Paylist, D2=Cycle, E2=Action). Data starts in Row 3 and will go down to row 5000. The dates would start 01-Jan-2011 and could go up to 31-Dec-2011.
Right now I have 2 macro's to sort by date and paylist but what I also need is a macro to allow the user to sort by the user inputting a from date (I think I can use a calendar to pick from) and a to date (option of => and =<) in a form. The next piece is how to display and be able to print this filtered info. I am not sure best option. Possibly only these rows be displayed and the other rows be hidden or maybe copy to a new page and after filtering the macro moves access to new page. I have also created a macro to open a user form1. So far I have (but no code yet to run) options to sort by Name, Date, Paylist, cycle and action. thx Mel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
