$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2012-12-19 Thread Prince
Hi Rashid Where is the out time of the employees. and if there are 100 emplyees then do you want 100 sheets in the workbook. Regards Prince On Wednesday, December 19, 2012 4:17:43 PM UTC+5:30, prkhan56 wrote: > > Hello All > > I am using excel 2007 > > I have data in the Mas

$$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

2012-12-19 Thread ..
Dear List members Request : *Mail merge and E mail* using VBA or other tools = - I have to send reminder / dunning letters to my customers. - Unfortunately the faxing option from the company is very time consuming (print,

Re: $$Excel-Macros$$ Date / Time Conversion Function or Macro Needed

2012-12-19 Thread ashish koul
try this =TEXT(B2,"mmddhhmm") see if it helps On Wed, Dec 19, 2012 at 10:36 PM, Bill Q wrote: > IE: January 8, 2012 9:01 would return a value of 201201080901. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -

Re: $$Excel-Macros$$ Date / Time Conversion Function or Macro Needed

2012-12-19 Thread Bill Q
Perfect ! From there I can convert it to numeric. Many thanks Ashish ! On Wednesday, December 19, 2012 1:09:01 PM UTC-5, ashish wrote: > try this =TEXT(B2,"mmddhhmm") see if it helps > > > > On Wed, Dec 19, 2012 at 10:36 PM, Bill Q > > wrote: > >> IE: January 8, 2012 9:01 would return a

Re: $$Excel-Macros$$ Date / Time Conversion Function or Macro Needed

2012-12-19 Thread Bill Q
Yes, that's perfect Jaysheel. Thank you. On Wednesday, December 19, 2012 1:16:28 PM UTC-5, JAY wrote: > Hi Bill, > > Try Using TEXT(B2,"MMDDHHMM"). > > I have attached your file with formula updated in Column J, Please check > and let me know if this is your requirement. > > Regards, >

Re: $$Excel-Macros$$ Re: Automatically autofilter and sort using vba

2012-12-19 Thread Yahya Muhammad
Hi Prince Thanks a lot. It's working fine. On Wed, Dec 19, 2012 at 7:52 PM, Prince wrote: > Hi Yahya, > > PFA. > > Regards > Prince > > On Wednesday, December 19, 2012 7:21:41 PM UTC+5:30, Yahya Muhammad wrote: >> >> >> Dear experts >> >> I have an excel workbook which is used to track my stoc

Re: $$Excel-Macros$$ Help with INSTR

2012-12-19 Thread Matt
Hi Anoop, That code was really helpful. I modified it to help do what I was trying to do. The only problem I have now is that It only seems to apply the type to the first match it finds and disregards the rest of them. Any Idea how I would be able to apply the code to the rest of the rows? H

$$Excel-Macros$$ Re: Numeric Typing Tutor_V1, made in MS-Excel.

2012-12-19 Thread Rajan_Verma
Looks nice now :) On Thursday, 20 December 2012 03:31:21 UTC+5:30, Bullet wrote: > > > Hi All, > > Kindly find attached the Numeric Typing Tutor_V1, made in MS-Excel. > > And append your suggestion to make it more dynamic. > > Few months back Mr. Rajan Verma, helped me a lot to make it, thanks a l

$$Excel-Macros$$ Re: Numeric Typing Tutor_V1, made in MS-Excel.

2012-12-19 Thread Prince
Very Nice. :) Regards Prince On Thursday, December 20, 2012 9:07:23 AM UTC+5:30, Rajan_Verma wrote: > > Looks nice now :) > > On Thursday, 20 December 2012 03:31:21 UTC+5:30, Bullet wrote: >> >> >> Hi All, >> >> Kindly find attached the Numeric Typing Tutor_V1, made in MS-Excel. >> >> And appen

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2012-12-19 Thread prkhan56
On Wednesday, December 19, 2012 2:47:43 PM UTC+4, prkhan56 wrote: > > Hello All > > I am using excel 2007 > > I have data in the Master Sheet for various Employees > > I want to create separate sheet for each employee viz A, B, C and so on > (see sample > sheet attache