Re: $$Excel-Macros$$ CCare Log Mgnt Sys

2014-08-26 Thread Vaibhav Joshi
Hi your requirement is chart 2, can you share excel file it self insted of screenshot to understand better how & why data flows/links to each other. Cheers!! On Sun, Aug 24, 2014 at 11:24 AM, veeru h wrote: > Hi, > I need a help. i am doing my brother small project i completed basic work > fo

$$Excel-Macros$$ Re: Only Excel formuala

2014-08-26 Thread Prince
=SUBSTITUTE(D9,"|","") Regards Prince On Tuesday, 26 August 2014 00:16:19 UTC+5:30, kamal ganeshan wrote: > > Hi Friends, > > Can anyone help me with the excel formula for the attached list of > question > > Regards, > Ganeshan > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

$$Excel-Macros$$ Urgent required Java Developer - Dublin, OH

2014-08-26 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: Java developerLocation: Dublin, OHDuration: 1 years* Candidates selected for OH would have to work initially at WA for 8 -10 weeks and then have to shift to OH Office JD: Please note: Framework technologies like Spring, Struts, etc.

$$Excel-Macros$$ Urgent required Java developer/ Architect - San Jose, CA

2014-08-26 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com Position: Java Developer/Architect (Solr)Location: San Jose, CADuration: 6+ Months* JD: - 5+ years experience with Solr (Apache Lucene), HTML, XML, Java, Tomcat, JBoss, MySQL - Experience implementing Solr builds of indexes, shards, and refined searc

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$$ Re: Create macro to save macro template as macro enabled workbook using cell value as file name

2014-08-26 Thread Paul Schreiner
Well, all I can say is, using Excel 2010:   If my original file type is .xls and I run a macro with:     ActiveWorkbook.SaveCopyAs Filename:="C:\temp\VBA\" & Range("E5").Value & ".xlsm"   It creates a file with a .xlsm extension, but when I open it I get: "Excel cannot open the file (filename) be

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 >