Re: $$Excel-Macros$$ HELP urgent

2011-07-13 Thread Rakesh Joshi
You Can use conditinoal formatting On Wed, Jul 13, 2011 at 4:05 PM, Jorge Marques wrote: > Hi friend, i don´t understand exactly what you want, but if you want to > highlight the entire row that has the negative numbers like this, or do you > want it to copy to another column the year and negati

RE: $$Excel-Macros$$ HELP urgent

2011-07-13 Thread Rajan_Verma
@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Wednesday, July 13, 2011 4:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ HELP urgent Hi friend, i don´t understand exactly what you want, but if you want to highlight the entire

Re: $$Excel-Macros$$ HELP urgent

2011-07-13 Thread Jorge Marques
Hi friend, i don´t understand exactly what you want, but if you want to highlight the entire row that has the negative numbers like this, or do you want it to copy to another column the year and negative value? Year Cash Available 2002 0 1983 6.71 1995 23.75 1994 21.06 2007 -11 2009 20 2011 29

RE: $$Excel-Macros$$ HELP urgent

2011-07-13 Thread Rajan_Verma
Please attach a sample file with more explaination.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Puneet Jain Sent: Wednesday, July 13, 2011 12:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ HELP urgent Guys Need Help.

Re: $$Excel-Macros$$ Help Urgent Please

2011-07-05 Thread ICWAI Help
its Not working getting the wrong emaild id s Hi Ashish the formula which u have provieded its working somewht but "out 10 geeitn the id for 2 employees id " Thanks, On Tue, Jul 5, 2011 at 10:48 PM, PRAVESH KUMAR wrote: > HI, > i think solved your quetions. > otherwise revert me. > Regards > Pra

Re: $$Excel-Macros$$ Help Urgent Please

2011-07-05 Thread ashish koul
hope you will get most of ids from these formula's c2 = VLOOKUP(LEFT(A2,FIND(" ",A2)-1)&"*",B:B,1,0) d2 = VLOOKUP("*"&RIGHT(A2,LEN(A2)-FIND("~",SUBSTITUTE(A2," ","~",LEN(A2)-LEN(SUBSTITUTE(A2," ",""),B:B,1,0) On Tue, Jul 5, 2011 at 9:58 PM, ICWAI Help wrote: > Search the employee name in

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

2011-06-02 Thread karan 1237
;>> >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *karan 1237 >>> *Sent:* Thursday, June 02, 2011 4:21 PM >>> >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

2011-06-02 Thread abdelrahman noaman
>> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *karan 1237 >> *Sent:* Thursday, June 02, 2011 4:21 PM >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

2011-06-02 Thread karan 1237
On Behalf Of *karan 1237 > *Sent:* Thursday, June 02, 2011 4:21 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!! > > > > Thnx a lot Rajan but I want one more thing that is it possible to make > input box character l

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

2011-06-02 Thread karan 1237
t; > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Vishal Gupta > *Sent:* Wednesday, June 01, 2011 8:05 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!! > > > > *Dear кαя

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

2011-06-02 Thread karan 1237
Thnx for this vishal but I dnt wnt to prtect sheet as you think I want to protect sheet in different way. I hope you'v seen that excel file which I'v attached. I made a combo box & I want to protect it like : I chose a name from combobox like Dharmendra mishra & now I want that when I choose name

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

2011-06-01 Thread Vishal Gupta
*Dear кαяαηη,* *Greetings for the day!!!* *to protect your sheet or workbook go to review pane in office 2007, then protect sheet, then limit of protection. by doing this u can protect ur project with a password.* ** Regards Vishal Gupta On Wed, Jun 1, 2011 at 3:58 PM, karan 1237 wrote: > > H

Re: $$Excel-Macros$$ Help Urgent Page break Preview Problem

2010-07-31 Thread Kumar Punnam
Hi , Use 'reset print area", or unhide the hiden rows, freeze panes and try it once . i hope this wil help you Ravi Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and lin