Mel, I did something similar to this (not sorting but filtering) for another project. If you put a sample file of yours, I can help.
Best, AJ On Thu, Mar 11, 2010 at 10:22 PM, Mel <mel.pilg...@agr.gc.ca> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
