Re: $$Excel-Macros$$ VBA code for adding new row at the end of last row

2014-08-20 Thread Vaibhav Joshi
did this worked? On Wed, Aug 20, 2014 at 4:41 PM, Vaibhav Joshi wrote: > Hi > > FA, since i hv used autofill method to continue sequence there should be > at least 2 set of data initially. > > Cheers!! > > PS: Do acknowledge/give feedback to post response. > > > > On Wed, Aug 20, 2014 at 8:57

Re: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

2014-08-20 Thread Ashish Kumar
Thanks Pankaj, but Full Credit goes to Vaibhav Sir. He is Genius. Regards Ashish On 21 August 2014 09:56, Pankaj Kumar wrote: > Thanks a ton to Ashish and Vaibav!! I looks good now. You guys are > brilliant. :) > > > On Wed, Aug 20, 2014 at 1:59 AM, Ashish Kumar > wrote: > >> Vaibhav Bro, >>

Re: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

2014-08-20 Thread Pankaj Kumar
Thanks a ton to Ashish and Vaibav!! I looks good now. You guys are brilliant. :) On Wed, Aug 20, 2014 at 1:59 AM, Ashish Kumar wrote: > Vaibhav Bro, > > Superb!!! > > > On 20 August 2014 12:12, Vaibhav Joshi wrote: > >> FA >> >> Cheers!! >> >> On Wed, Aug 20, 2014 at 8:03 AM, Pankaj Kumar

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$$ VBA code for adding new row at the end of last row

2014-08-20 Thread Vaibhav Joshi
Hi FA, since i hv used autofill method to continue sequence there should be at least 2 set of data initially. Cheers!! PS: Do acknowledge/give feedback to post response. On Wed, Aug 20, 2014 at 8:57 AM, Pankaj Kumar wrote: > Hello VBA/macro Expert group, > > I've attached file in which I wa

$$Excel-Macros$$ Lets move into the Nominations

2014-08-20 Thread carol . fonsekaa
*Dear Professional Colleague,* Greetings! Be part of Global Leadership Awards 2014 on 20th December, 2014 by Federation of Industries. Request you to kindly nominate/send delegates from your Organization or send nominations for awards. Also contact us if you are interested in tie-up/co

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

Re: Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

2014-08-20 Thread Ashish Kumar
Vaibhav Bro, Superb!!! On 20 August 2014 12:12, Vaibhav Joshi wrote: > FA > > Cheers!! > > On Wed, Aug 20, 2014 at 8:03 AM, Pankaj Kumar wrote: > >> Hello Ashish and Vaibhav, >> >> You guys are genius. Thanks a lot for modified code. However, it seems. >> It still has limitation. >> It's