Re: $$Excel-Macros$$ conditional formate help

2014-01-29 Thread excel lerner
> excel-macros@googlegroups.com] *On Behalf Of *excel lerner > *Sent:* Wednesday, January 29, 2014 2:51 PM > *To:* excel-macros > *Subject:* $$Excel-Macros$$ conditional formate help > > > > Sir > > Please find the attachment and help me.its urgent. > > thanks

$$Excel-Macros$$ conditional formate help

2014-01-29 Thread excel lerner
Sir Please find the attachment and help me.its urgent. thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate t

$$Excel-Macros$$ Numbers in words with formula

2013-11-28 Thread excel lerner
Hi experts Please help me to convert numbers in to words in excel 2007.is there any formula to cinvert. Rs.1234 .56 Result is One thousand two hundred and thirty four and fifty six paisa thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,D

Re: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria

2013-07-19 Thread excel lerner
------ > From: excel lerner > Date: Fri, Jul 19, 2013 at 2:43 PM > Subject: Re: $$Excel-Macros$$ formula required to update values form one > sheet to another sheet with date criteria > To: excel-macros > > > thanks for suggestion.can u explain > > > On

Re: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria

2013-07-19 Thread excel lerner
thanks for suggestion.can u explain On Fri, Jul 19, 2013 at 2:38 PM, Pravin Gunjal wrote: > Pl use v-lookup. > > -- Forwarded message -- > From: excel lerner > Date: Fri, Jul 19, 2013 at 10:20 AM > Subject: $$Excel-Macros$$ formula required to update values f

$$Excel-Macros$$ require hospital pharmacy software

2013-04-22 Thread excel lerner
Sir can any body suggest me where can i get free to download hospital pharmacy software or excel template with batch& expiry reports Thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ mouse right click option not working in excel sheets

2013-04-02 Thread excel lerner
> > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 > naukrikuld...@gmail.com || www.naukri.com > *Please* *Consider the environment. Please don't print this e-mail unless > you really need to.* > * > *

$$Excel-Macros$$ mouse right click option not working in excel sheets

2013-04-02 Thread excel lerner
good evening experts I am using excel 2007.In my excel work book i have 10 sheets with defferent names.i want to colour the sheet tabs.when i right click on sheet name with mouse nothing open.previously i used right click and change the color,rename and hide&unhide the sheets.Any help -- Are y

Re: $$Excel-Macros$$ how to insert logo in excel print

2013-02-07 Thread excel lerner
Hi Kuldeep Sir I didnt find any advance options in my printer settings.I am using HP laser jet 1020 Plus -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

$$Excel-Macros$$ happy new year

2012-12-31 Thread excel lerner
I wish You a very happy New Year to all Grou Members -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advi

$$Excel-Macros$$ hlep to convert pdf to excel

2012-12-21 Thread excel lerner
Hello sir How to convert pdf file to excel.please help me sir Thanks in advance -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ need formula help

2012-12-09 Thread excel lerner
Sir Please see the sample and help me.In this file Row C4 to AD 4 has amount to be paid for each unit.If emp-1 done 2 units in c5 then c5*c4 , emp-2 done 3 units in c6 then c6*c4. as same up to AD to all employes. I already set formula in AE for all employes.Please verify and suggest me for simp

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

2012-11-06 Thread excel lerner
Thanks for your help. Every solution is working and fine. Thanks once again friends -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Ple

$$Excel-Macros$$ Calculate years and months between today daye and given date

2012-11-05 Thread excel lerner
Hello sir Can you please explain how to get completd years ,Months bet ween todays date and pevius year date.example 01/04/1954 05/11/2012 please tell me the formula thanq sir -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members alre

Re: $$Excel-Macros$$ automatic update totals in cumulative colums

2012-09-06 Thread excel lerner
ative sum > > =SUM($E$4:E4,$F$4:F4) in cell G4 File 1 > > > > > > > On Thu, Sep 6, 2012 at 2:58 PM, excel lerner wrote: > >> Hello sir >> >> In my attached files file1.xls is one month reports. file2.xls is next >> month reports. >> >

$$Excel-Macros$$ automatic update totals in cumulative colums

2012-09-06 Thread excel lerner
Hello sir In my attached files file1.xls is one month reports. file2.xls is next month reports. I want to cumulative values in cumulative columns automatically when i enterd present month values in monthly columns. Please help me. Thanks in advance -- Join official facebook page of this foru

Re: $$Excel-Macros$$ MACRO

2012-05-29 Thread excel lerner
Noorin Sir Please send send VBA Ebook 2007(O'Rellay) on your email ID exceller...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advic

Re: $$Excel-Macros$$

2011-12-28 Thread excel lerner
On Wed, Dec 28, 2011 at 11:40 AM, excel lerner wrote: > hi >> > Don Guillett Thanks for ur help.Please clarify one more doubt.code in that > file working good. c6 cumilative is 20 for before month.But c7 cumulative > is different and so on. > ur code is updating c6 cumula

Re: $$Excel-Macros$$

2011-12-27 Thread excel lerner
> > hi > Don Guillett Thanks for ur help.Please clarify one more doubt.code in that file working good.Can i copy the code to my needy file .Is it works? or any modicifcations in that. > > Thanq > > -

Re: $$Excel-Macros$$

2011-12-27 Thread excel lerner
All 20 sheets in one month file. Ex. November month file has 20 sheets and december month file has 20 sheets. every sheet has its won name and every file named as month-year ex.nov-11,dec-11. suppose in nov-11 sheet11 named as abc the same name will continue in dec-11.In cumulative totals in abc sh

$$Excel-Macros$$

2011-12-27 Thread excel lerner
thanks for ur quick rely Mr.Rajan Verma Please find the attachment -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick atte

$$Excel-Macros$$ how to update sheets from other sheets

2011-12-27 Thread excel lerner
get data from other files also. how can i get this. thanks in advance urs faithfully excel lerner -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and

Re: $$Excel-Macros$$ Power point Query

2011-09-20 Thread excel lerner
Hi Dear Alisha Thanks for explain abt powerpoint presentaion shape rotate. thanks for your help. regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit