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

2014-08-27 Thread Vaibhav Joshi
Cheers!! On Wed, Aug 27, 2014 at 1:24 PM, SG wrote: > Vabz sir, thanku so much > really you helped me alot...Hats off:) > > > On Tuesday, August 26, 2014 11:46:12 PM UTC+5:30, Vabz wrote: > >> place all sheets to be updated in one folder, run macro & select that >> folder, & data will get c

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

2014-08-27 Thread SG
Vabz sir, thanku so much really you helped me alot...Hats off:) On Tuesday, August 26, 2014 11:46:12 PM UTC+5:30, Vabz wrote: > > place all sheets to be updated in one folder, run macro & select that > folder, & data will get consolidated in this book. > > Cheers!! > > > On Tue, Aug 26, 2014

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

2014-08-26 Thread Vaibhav Joshi
place all sheets to be updated in one folder, run macro & select that folder, & data will get consolidated in this book. Cheers!! On Tue, Aug 26, 2014 at 4:49 PM, SG wrote: > gr88...then will you please help me on this. > > > On Tuesday, August 26, 2014 4:27:32 PM UTC+5:30, Vabz wrote: > >> ye

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

2014-08-26 Thread SG
gr88...then will you please help me on this. On Tuesday, August 26, 2014 4:27:32 PM UTC+5:30, Vabz wrote: > > yes > > > On Tue, Aug 26, 2014 at 3:36 PM, SG > > wrote: > >> yes sir..absolutely right.. >> >> is it feasible na? >> >> On Tuesday, August 26, 2014 2:59:02 PM UTC+5:30, Vabz wrote: >> >>

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

2014-08-26 Thread Vaibhav Joshi
yes On Tue, Aug 26, 2014 at 3:36 PM, SG wrote: > yes sir..absolutely right.. > > is it feasible na? > > On Tuesday, August 26, 2014 2:59:02 PM UTC+5:30, Vabz wrote: > >> Ok. Do you want to first merge 4 weekly scorecard in to 1 and then ctrate >> employee wise feedback sheet. >> >> 2nd part is

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

2014-08-26 Thread SG
yes sir..absolutely right.. is it feasible na? On Tuesday, August 26, 2014 2:59:02 PM UTC+5:30, Vabz wrote: > > Ok. Do you want to first merge 4 weekly scorecard in to 1 and then ctrate > employee wise feedback sheet. > > 2nd part is ready now you want macro for first part. > > Am I correct. >

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

2014-08-26 Thread Vaibhav Joshi
Ok. Do you want to first merge 4 weekly scorecard in to 1 and then ctrate employee wise feedback sheet. 2nd part is ready now you want macro for first part. Am I correct. On Aug 26, 2014 2:38 PM, "SG" wrote: > Vabz, > This would be used for monthly feedback. For monthly, i have to > consolidate

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

2014-08-26 Thread SG
Vabz, This would be used for monthly feedback. For monthly, i have to consolidate those 4 scorecard files which are prepared on weekly baisi & then i prepare the feedback for each. This requires the consolidation of scores of those 4 files. I hope i'm able to clear all doubts. On Tuesday, Augu

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

2014-08-26 Thread Vaibhav Joshi
How do you want data in feed back sheet, do you want to add for 2 period or in separate sheet? On Tue, Aug 26, 2014 at 1:11 PM, SG wrote: > Hi Vabz, > > Any update on this. Can it be consolidated in any other way. > > please,can anybody else also look in to this. > > On Monday, August 25, 2014

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

2014-08-26 Thread SG
Hi Vabz, Any update on this. Can it be consolidated in any other way. please,can anybody else also look in to this. On Monday, August 25, 2014 7:50:13 PM UTC+5:30, SG wrote: > > some of the criterias are to consolidate the > scores of users for region "UK" & location "b". The header & yellow >

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

2014-08-25 Thread Vaibhav Joshi
Hi File which you shared contains data for one week only. Cheers!! On Mon, Aug 25, 2014 at 6:49 PM, SG wrote: > Hi Vabzzz.. > > I need one more help in this. As you have seen the scorecard file, that > should be summary of four weeks & thehn the feedback would be prepared. Can > you please al

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

2014-08-25 Thread SG
Hi Vabzzz.. I need one more help in this. As you have seen the scorecard file, that should be summary of four weeks & thehn the feedback would be prepared. Can you please also help me in consolidation of those four files in to one file. It would be a great help. On Monday, August 25, 2014 3:3

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

2014-08-25 Thread SG
Thanku so much vabz for clarification... On Friday, August 22, 2014 12:11:04 PM UTC+5:30, Vabz wrote: > > 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. Af

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

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$$ 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$$ 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

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

2014-08-20 Thread Vaibhav Joshi
hi dont use double click, it is for only single sheet update. You have to just run a macro, check this file, click blue button.. Make sure both files are open. Cheers!! On Wed, Aug 20, 2014 at 8:20 PM, SG wrote: > Hi Vabz, > > i'm really not getting it. how to work. on double click on name

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

2014-08-20 Thread SG
Hi Vabz, i'm really not getting it. how to work. on double click on name, it asks "please select one of file". How hsould i start & how would it create userwise seperate sheets. Please help out. On Wednesday, August 20, 2014 8:04:44 PM UTC+5:30, Vabz wrote: > > ok, chek this!! > > Cheers!! > >

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

2014-08-20 Thread Vaibhav Joshi
ok, chek this!! Cheers!! On Wed, Aug 20, 2014 at 6:11 PM, SG wrote: > Hi Vabz, > > Thanks so much for the help but it's not solving the purpose. User wise > seperate sheets are not made in feedback workbook & also the values of > errors for "rahul" are incorrect. > Can you please check it. Als

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

2014-08-20 Thread SG
Hi Vabz, Thanks so much for the help but it's not solving the purpose. User wise seperate sheets are not made in feedback workbook & also the values of errors for "rahul" are incorrect. Can you please check it. Also i didn't get the logic behind clicking the name (col d) part. On Wednesday, Au

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

2014-08-20 Thread Vaibhav Joshi
FA macro. Also if you want to update single sheet then keep both feedback sheet & scorecard sheet open together then in scorecard book double click on name (col D) and u will get prompted to select sheet to update with existing values. Cheers!! On Tue, Aug 19, 2014 at 7:39 PM, SG wrote: > Hi

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

2014-08-20 Thread SG
Hi Vabz, Through macro because this would be prepared monthly. for this, it would open 4 scorecard files of a month,consolidate their scores & then prepare the feedback. On Wednesday, August 20, 2014 1:07:07 PM UTC+5:30, Vabz wrote: > > hi > > how do you want to achieve result thru formula or m

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

2014-08-20 Thread Vaibhav Joshi
hi how do you want to achieve result thru formula or macro?? Cheers!! On Tue, Aug 19, 2014 at 7:39 PM, SG wrote: > Hi Experts, > > I need your help in preparation of a feedback sheet through macro. My > requirement is to create name wise feedback worksheet in a workbook > which contains th

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

2014-08-19 Thread SG
Hi Experts, I need your help in preparation of a feedback sheet through macro. My requirement is to create name wise feedback worksheet in a workbook which contains their data from "scorecard" sheet. one of the criteria is to create the name wise sheet for only region "uk" & location "b" user