Hi, The Recd Date and Completion date is differs for each employee. So you mean to say that date range has to be generated for each employee.
Could you suggest the format in which you want this to be done ? Regard Vasant > Hi Vasant, > > This works great. Thanks for your help. Need a small change on this. > > The attached file will have dates already presented in sheet "Dummy". Now > what I want to have the dates automatically populated when macro running. > > The macro should check the minimum date in column E(Recv Date) and maximum > date in column F(Compleation Date). Then it should populate the dates from > min date to max date automatically. > > As and when I run the macro it should populate the dates based on minimum > and maximum automatically. > > Note: if min date is 09/07/2010 and max date is 12/08/2010 then the macro > should populate dates from cell B2-09/07/2010, B3-10/07/2010, > B4-11/07/2010........12/08/2010. till the last date. > > Thanks for your time, > > Looking for your help to proceed further. > > Thanks again, > Sharma > > On Tue, Jul 27, 2010 at 9:39 AM, Vasant <vasant...@gmail.com> wrote: > >> Hope this is works... >> >> Regards >> Vasant >> >> >> On Tue, Jul 27, 2010 at 4:22 PM, amrahs k <amrahs...@gmail.com> wrote: >> >>> Hi Dilip, >>> >>> I have attached the sample file with my query. Please look into this and >>> help me to proceed further since i have left with only one working day. >>> >>> Looking for your help, >>> >>> Thanks in Advance, >>> Sharma >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 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 7000 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 >>> >> >> >> >> -- >> Regards >> >> Vasant >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 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 7000 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 7000 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 > -- Regards Vasant -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 7000 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
