It looks like this is what I need however, I have Excel version 2003 not 2007 so it does not conver over and work. any chance you can re-save in 2003 version? thx Mel
On Mar 14, 5:02 am, Deepak Rai <daksh1...@gmail.com> wrote: > Hi Mel, > > I have a sample macro which work like similar as you want. Please find the > attached. > > Hope this will help. > > Thanks, > > Deepak Rai > > On Fri, Mar 12, 2010 at 10:50 AM, Abhishek Jain <abhishek....@gmail.com>wrote: > > > > > > > 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 athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > -- > Thanks, > > Deepak Rai > > Solved Answer (Mel).xlsm > 45KViewDownload- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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
