Re: $$Excel-Macros$$ Create user wise feedback sheet

2014-08-21 Thread Vaibhav Joshi
Old module is for creating files in wrokbook insted in feedback sheet. I have also created Macro for updating only 1 sheet, wherein you needed to keep open scorecard & feedback book. After that doble click on name of person whose record you wanted to update, post double clicking on name a userform

Fwd: $$Excel-Macros$$ Doubt MBA

2014-08-21 Thread Marcio Bandeira
i forgot something very importante. I need a extra collum to say if I send the file to this cliente or not. New example. Tks!!! Hi. I need a help. I have a worksheet and I need to build a macro that send a file, with the name is in collum B to the e-mails at collum c. THere is a Excel attached to

$$Excel-Macros$$ Doubt MBA

2014-08-21 Thread Marcio Bandeira
Hi. I need a help. I have a worksheet and I need to build a macro that send a file, with the name is in collum B to the e-mails at collum c. THere is a Excel attached to explain. I apreciate any help. Thank you very much Marcio. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo

Re: $$Excel-Macros$$ Need Help

2014-08-21 Thread Vaibhav Joshi
since your value is not stored as time it is giving incorrect result., convert it to time or manually re enter values you will get correct result. Cheers!! On Thu, Aug 21, 2014 at 6:19 PM, karthik N wrote: > Hi Vaibhav > > Thanks for replay, > > But one small doubt > > SNo Gender Name Shift

Re: $$Excel-Macros$$ Need Help

2014-08-21 Thread karthik N
Hi Vaibhav Thanks for replay, But one small doubt SNo Gender Name Shift InTime OutTime Tot. Dur. Gents Ladies 2 MR karthik Sam 01:44 21:52 4:36 Yes - 3 MR ANAND GS 09:28 21:16 7:42 Yes - Intime 8 MR NIRMAL GS 09:28 21:18 10:14 Yes - <09:30 12 MR RAJI GS 10:22 22:35 10:48 Yes - >09.30

Re: $$Excel-Macros$$ Create user wise feedback sheet

2014-08-21 Thread SG
Vabz sirhats offthnku so much...really gr88 now i have some questions so that i can clear my doubt. what you have created a code name " create old feedback " & what is the use of Option Explicit Public MyFile As String Public Stopped As Boolean On Thursday, August 21, 2014 2:53:50 PM U

Re: $$Excel-Macros$$ Need Help

2014-08-21 Thread Vaibhav Joshi
Check this.. Cheers!! On Thu, Aug 21, 2014 at 3:00 PM, karthik N wrote: > Dear Sir, > > How many ladies came before 9.30 and left 7.30 > > SNo Gendal Name Shift InTime OutTime Tot. Dur. Gents Ladies 1 Ms Priya > S GS 9:30 19:30 10:00 - Yes 2 Mr karthik Sam 01:44 21:52 4:36 No - 3 Mr >

Re: $$Excel-Macros$$ Need Help

2014-08-21 Thread karthik N
Dear Sir, How many ladies came before 9.30 and left 7.30 SNo Gendal Name Shift InTime OutTime Tot. Dur. Gents Ladies 1 Ms Priya S GS 9:30 19:30 10:00 - Yes 2 Mr karthik Sam 01:44 21:52 4:36 No - 3 Mr ANAND GS 09:28 21:16 7:42 No - 4 Mr Kavirajan ST GS 10:03 19:08 8:46 No - 5 Mr SURESH GS

Re: $$Excel-Macros$$ Create user wise feedback sheet

2014-08-21 Thread Vaibhav Joshi
FA Cheers!! On Thu, Aug 21, 2014 at 1:43 PM, SG wrote: > Hi Vabz > > Great.. :) Thanku so much..please only one change is needed in total > external errors & internal errors(row 9 &10 of feedback sheet), the sum of > errors should come not the score. > Please can you change it. > Thanks al

Re: $$Excel-Macros$$ Need Help

2014-08-21 Thread Vaibhav Joshi
you want only count of ladies / gents? Or in case of ladies, do you want how many of them came before 9:30 & left after 7:30?? On Thu, Aug 21, 2014 at 2:04 PM, karthik N wrote: > Dear Sir, > > Please find the attached file.. > > we have to calculate time duration starting from 09:30 to 07:30 f

$$Excel-Macros$$ Need Help

2014-08-21 Thread karthik N
Dear Sir, Please find the attached file.. we have to calculate time duration starting from 09:30 to 07:30 for ladies and gents we have to calculate duration starting from 09:30 to 08:30 How many ladies working in between 09:30 to 07:30 How many gents working in between 09:30 to 08:30 --

Re: $$Excel-Macros$$ Create user wise feedback sheet

2014-08-21 Thread SG
Hi Vabz Great.. :) Thanku so much..please only one change is needed in total external errors & internal errors(row 9 &10 of feedback sheet), the sum of errors should come not the score. Please can you change it. Thanks alot ... On Wednesday, August 20, 2014 8:30:40 PM UTC+5:30, Vabz wro