Re: $$Excel-Macros$$ Summary for a Weekly report-Urgent

2012-01-11 Thread lucky singh
dear team, Require you urgent help.. Thanks On Thu, Jan 12, 2012 at 12:16 PM, lucky singh wrote: > > Dear Team, > > Require a dashboard or a summary sheet for the attached weekly resource > planning report. > > The format should be simple and better to understand.

$$Excel-Macros$$ Summary for a Weekly report

2012-01-11 Thread lucky singh
Dear Team, Require a dashboard or a summary sheet for the attached weekly resource planning report. The format should be simple and better to understand. Thanks in Advance, Regards, Lucky -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor t

Re: $$Excel-Macros$$ Hyperlink to Highlight weekly data

2011-12-29 Thread lucky singh
my cursor should automatically go on the data on next sheet On Thu, Dec 29, 2011 at 7:05 PM, dguillett1 wrote: > I don’t understand your request. “it should highlight” > examples > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* lucky singh >

$$Excel-Macros$$ Help on chart

2011-12-27 Thread lucky singh
Hi Team, Request you to kindly help I want is a grid on the right & the red line to be highlighted properly with the blue lines Regards, Lucky S -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

Re: $$Excel-Macros$$ Help for If nesting formula

2011-11-29 Thread lucky singh
2>=$F$4,A2<=$G$4),"6-9 > Month",IF(AND(A2>=$F$5,A2<=$G$5),"9-12 > Month",IF(AND(A2>=$F$6,A2<=$G$6),">12 Month","Prospect") > > > On Wed, Nov 30, 2011 at 12:09 PM, lucky singh wrote: > >> >> Hello Team,

$$Excel-Macros$$ Excel-Macros for protecting cell

2011-08-02 Thread lucky singh
Hi Team, Attached below is the Marco code for Protecting cells in excel sheet. Steps to Protect a cell Step 1 - Open that particular file which you want to lock and hide any formulas in sheet. Step 2 - Open file "PROTECT" and press CTRL + j Steps to Unprotect a cell Step 1 - Open that particul

$$Excel-Macros$$ Excel-Macros for protecting cell

2011-08-02 Thread lucky singh
Hi Team, Attached below is the Marco code for Protecting cells in excel sheet. Steps to Protect a cell Step 1 - Open that particular file which you want to lock and hide any formulas in sheet. Step 2 - Open file "PROTECT" and press CTRL + j Steps to Unprotect a cell Step 1 - Open that particul

$$Excel-Macros$$ Indirect Formula Help required...

2011-06-10 Thread lucky singh
Hi Team, Required help for indirect formula... Thanks in advance, Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

Re: $$Excel-Macros$$ Please help me

2011-01-19 Thread lucky singh
Hi Sudhir, PFA... Regards, Lucky On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar wrote: > Hi > > All Dear members > > Plz help on the following point. > > I want count no. of Days between two Dates. > > Example > > 1-12-10 31-12-1031 > > thanx > > > -- > Sudhir Verm

Re: $$Excel-Macros$$ Separate the values in different columns

2011-01-19 Thread lucky singh
hi kanti, can u help me to extract only the mobile numbers + 022-2 Ex-6432341 ~+ 9870188646 + 022-2 Ex-6487723 + 022-2 Ex-6658518 ~+ 9821916656 + 022-2 Ex-6795123 + 0251- Ex-2311543 ~+ 9869478989 ~+ 2311543 +91 (022) 9920283747 ~+91 (91) 9221201496 + (0832) 2217393 ~+91 (0

Re: $$Excel-Macros$$ Fwd: need help

2011-01-19 Thread lucky singh
quot;Summary").Cells(z + 7, k).Value = Sheets("score").Cells(34, > 2).Value > > > > For s = z To z + 7 > > > > If Sheets("Summary").Cells(s + 1, k).Value = "GOOD" Then > > Sheets("Summary").Cells(s + 1, k).Value = 10 > &

Re: $$Excel-Macros$$ Fwd: need help

2011-01-18 Thread lucky singh
sorry ashish, the file is not working when i click on update it opens a pop up says read only, notify & cancel... Regards, On Tue, Jan 18, 2011 at 8:56 PM, ashish koul wrote: > check the attachment > > On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote: > >> >

$$Excel-Macros$$ Fwd: need help

2011-01-17 Thread lucky singh
Hello, Guys Need your help urgently please Regrads -- Forwarded message -- From: lucky singh Date: Tue, Jan 18, 2011 at 10:51 AM Subject: need help To: excel-macros@googlegroups.com Hi Guys need your help, I have 25 agenst overall & I have to record & list

$$Excel-Macros$$ need help

2011-01-17 Thread lucky singh
Hi Guys need your help, I have 25 agenst overall & I have to record & listen to 12 calls per agent, While rating a call i'll put scores in sheet one & automatically it should get updated in sheet 3 i.e. summary sheet & all the scores shuld get accumulated... Thanx in advance Regards, Lucky --

$$Excel-Macros$$ Want a formula that find the value as positive or pending as per horizontal and vertical.

2011-01-10 Thread lucky singh
Hi Friends, Want a formula that find the value as positive or pending as per horizontal and vertical. Thanx... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http:/

Re: $$Excel-Macros$$ HAPPY NEW YEAR 2011

2010-12-31 Thread lucky singh
Wish u the same dudue does any one has excel greetings for new year if yes den plz do forward it to me Regards, Lucky On Fri, Dec 31, 2010 at 12:20 PM, SAJID MEMON wrote: > Dear All Experts, > > I would like to wishing you "A VERY VERY HAPPY NEW YEAR 2011, YOU WILL BE > MORE EXPERT IN V

Re: $$Excel-Macros$$ Merry Christmas & Happy new year...

2010-12-24 Thread lucky singh
Thanx a lot venkat does any one has more of it... Regards, Lucky On Fri, Dec 24, 2010 at 4:17 PM, Venkat wrote: > Hi Lucky, > > Find attached > > Best Regards, > > Venkat Cv > > On Fri, Dec 24, 2010 at 11:15 AM, lucky singh wrote: > >> >

$$Excel-Macros$$ Merry Christmas & Happy new year...

2010-12-24 Thread lucky singh
Hi Guys, Do anyone has a excel greetings for Christmas or new year... plz do forward. Thanx in advance, Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Fwd: Specialized Data Analyst position with a Global MNC (no night shifts) ( if anyone interested )

2010-12-17 Thread lucky singh
Hi Ashish, Jay here working as a Sr. MIS Analyst... Do u have any thing for mumbai... Regards, Jay S On Sat, Dec 18, 2010 at 11:51 AM, ashish koul wrote: > > > > Hi, > > We have an urgent opportunity with one of our clients for the position of > Reporting Data Analyst, > > Position: Specializ

$$Excel-Macros$$ need your help on Validation

2010-12-14 Thread lucky singh
Hi All, need your help on validation if i select softdiet then only the menu of soft diet should be shown in dropdown & not hard diet similarly to hard diet on hard diet should be shown in dropdown & not soft diet... Regards, Lucky -- --

Re: $$Excel-Macros$$ need formula to extract on email ids

2010-12-14 Thread lucky singh
t; On Mon, Dec 13, 2010 at 9:37 PM, in.vaib...@googlemail.com < > in.vaib...@gmail.com> wrote: > >> Hi Lucky, >> >> PFA, Formula pasted n column C. >> >> WR// >> >> Vaibhav J. >> >> >> http://www.signaturebar.com/>> htt

$$Excel-Macros$$ need formula to extract on email ids

2010-12-13 Thread lucky singh
Hi All, need formula to extract on email ids Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN grou

$$Excel-Macros$$ Need help to get the collection date with the help of formula

2010-12-10 Thread lucky singh
Hi All, kindly help me to get the collaction date with the help of an formula... please refer the attachment... Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

$$Excel-Macros$$ plz help to automate diet chart

2010-11-19 Thread lucky singh
hi Guys plz help me to automate diet chart Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group

$$Excel-Macros$$ plz help to automate diet chart

2010-11-18 Thread lucky singh
hi Guys plz help me to automate diet chart Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group

$$Excel-Macros$$ Formula Correction

2010-08-25 Thread lucky singh
Hi, Need help in formula... I just need the only the first name to be extracted without space or gap... Regards, Jay S 8108932708 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

2010-06-30 Thread lucky singh
Thank you... Thanx a lot dude... Regards, Jay S On Wed, Jun 30, 2010 at 5:06 PM, devi prasadc wrote: > Hi Jay, > > I could get solutions for couple of things only. > > Regards > DeviPrasad > > On Wed, Jun 30, 2010 at 4:03 PM, lucky singh wrote: > > &

Re: $$Excel-Macros$$ Re: Exrtact only numbers.

2010-06-30 Thread lucky singh
4 variours formulas reuired... sample attached along... Regards, Jay S On Wed, Jun 30, 2010 at 3:21 AM, r wrote: > > > On 29 Giu, 12:05, lucky singh wrote: > > Hi All, > > > > 1. I want to extract all the numbers > > 2. I want to trim only the middl

$$Excel-Macros$$ Urgent formula required for Stock forecasting...

2010-06-29 Thread lucky singh
Hi All, urgent help required for forecasting stock in warehouse I have 8 products in my warehouse month on month the balance get deducted from it as and when it get sale However I need to know the available stock because it takes 50 days for my order Regards, Jay S 9987337414 -- -

$$Excel-Macros$$ Exrtact only numbers.

2010-06-29 Thread lucky singh
Hi All, 1. I want to extract all the numbers 2. I want to trim only the middle name Regards, Jay S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

$$Excel-Macros$$ Help required with if formula

2010-05-12 Thread lucky singh
Dear All, Kindly help with the IF formula in the attached sheet asap. Thanks an advance. Regards, Lucky Singh Sr. MIS Analyst. 9987337414 -- -- Some important links for excel users: 1. Follow us on TWITTER for