Hi Mel,
This macro is very very useful. Could you please have its codes reexamined
as it does not give any output if start date ("I2") is greater than A3 i.e
first cellThanks and regards R Singh -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mel Sent: Wednesday, March 17, 2010 7:38 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Macro to filter dates using Userform1 & printing 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 -- ---------------------------------------------------------------------------------- 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 To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
