Re: $$Excel-Macros$$ Fwd: Help Needed_Very Urgent

2010-07-30 Thread amrahs k
Hi Vasant,

I have sent an email to you with regard to the date ranges. Please refer
that mail and do the needful. Thanks a lot for your help.

Regards,
Sharma

On Thu, Jul 29, 2010 at 10:31 PM, Vasant vasant...@gmail.com wrote:

 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/201012/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
 

Re: $$Excel-Macros$$ Fwd: Help Needed_Very Urgent

2010-07-29 Thread Vasant
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/201012/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