not sure but how do I re-format or move fields around without causing the dates for the calendar to fail?
I am also trying to format the table of values (A3 to E5000) but cannot. On Mar 16, 8:31 pm, Deepak Rai <daksh1...@gmail.com> wrote: > Hi Mel, > > Please find the updated file which can be use with Excel 2003. > > Regards, > > Deepak Rai > > > > > > On Tue, Mar 16, 2010 at 6:45 PM, Mel <mel.pilg...@agr.gc.ca> wrote: > > 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 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).xls > 91KViewDownload- 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
