Re: $$Excel-Macros$$ Please Help

Hi Running balance mean's outstanding of Parties on left side display date. Pending amount mean's pending bills upto outstanding. thanx On 19 March 2011 05:27, Umesh Dev wrote: > Hi Sudhir, > > It is still not clear, how to get the Running Bal and the Pending Amount. > > > Regards > Umesh >

Re: $$Excel-Macros$$ Please Help

Hi Sudhir, It is still not clear, how to get the Running Bal and the Pending Amount. Regards Umesh On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar wrote: > Dear Experts, > > > Please read my attachment and solve it. > > thanx > > > > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

$$Excel-Macros$$ Please Help

Dear Experts, Please read my attachment and solve it. thanx <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Sudhir Verma Asstt. Mngr. A/c's 9818479722 -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ Please help on Excel.

sorry, use this formula in data validation =CONTAR.SI ($C$2:$C$30;C2)=1 2011/3/9 ChilExcel > Hi > > use this formula in data validation > > =CONTAR.SI($C$2:$C$30;C1)=1 > > > > chilexcel > > > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube

Re: $$Excel-Macros$$ Please help on Excel.

Hi use this formula in data validation =CONTAR.SI($C$2:$C$30;C1)=1 chilexcel Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 2011/3/8 Rabindra Thapa > Dear all, > > > > I have one attach file where I am keeping the serial pipe number b

Re: $$Excel-Macros$$ Please help on Excel.

see if it helps On Tue, Mar 8, 2011 at 8:51 PM, Rabindra Thapa wrote: > Dear all, > > > > I have one attach file where I am keeping the serial pipe number but the > problem is I am getting the same pipe number many times and it’s hard to > search whether provide pipe number are reported or not

$$Excel-Macros$$ Please help on Excel.

Dear all, I have one attach file where I am keeping the serial pipe number but the problem is I am getting the same pipe number many times and it's hard to search whether provide pipe number are reported or not. Can u have any formula/validation i.e. when I type the reported pipe number its

Re: $$Excel-Macros$$ -- Please Help Code Doesn't Work

Plz share your code On Feb 21, 2:06 pm, rakesh kumar wrote: > Hi Dearests, > > Please Help Code Doesn't Work > > On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar > wrote: > > > > > > > > > > > *thanks Daniel Ji for the reply... here what I need and what the code > > doesn't do.* > > * > > * > > *Th

Re: $$Excel-Macros$$ -- Please Help Code Doesn't Work

Hi Dearests, Please Help Code Doesn't Work On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar wrote: > *thanks Daniel Ji for the reply... here what I need and what the code > doesn't do.* > * > * > *This code runs as long as the Sheets("1").Cells(2, ColNumber) = > Sheets("Name").Cells(RowCounter, 1)

Re: $$Excel-Macros$$ Please Help

arre you using excel 2003 or 2007 if you are using 2007 simply apply filter by color On Fri, Feb 18, 2011 at 3:49 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: > Dear All, > > I have cash entries in one workbook and I want total of some specific > entries in different workbook

$$Excel-Macros$$ Please Help

Dear All, I have cash entries in one workbook and I want total of some specific entries in different workbook. Please can you help me on the same. Regards, Shrinivas -- -- Some important links for excel users: 1.

$$Excel-Macros$$ Please help in P Table.

Dear All, my Question is we can use use two header in p. Table.? -- Thanks & Regards Anil Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twi

RE: $$Excel-Macros$$ Please help

Thankyou verymuch paul -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bhushan Sent: Tuesday, February 01, 2011 5:53 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Please help Dear All, We use $ sign in formula to

Re: $$Excel-Macros$$ Please help

ces. > > the $A is the ABSOLUTE column A. > so when you copy it, it remains "A" > but for "B", well, the current cell is column "B", > so when you copy it to column C, the formula changes > to "C".. > > does that help? > > Paul > > __

Re: $$Excel-Macros$$ Please help

Hi sudhir, Click *Conditional formatting* tab ->Select *New Rule* -> Select *Format only cells that contain* -> click on *Format* and choose the color. Regards Umesh Dev On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar wrote: > Dear Experts > > > please hep me for a formula which worked on co

Re: $$Excel-Macros$$ Please help

Result attached Aamir Shahzad On Sat, Jan 29, 2011 at 9:13 PM, sudhir kumar wrote: > Dear Experts > > > Please help see my attachement and help me. > > > thanking you > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > > P think Befo

Re: $$Excel-Macros$$ Please help

check the attachment On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar wrote: > Dear Experts > > > please hep me for a formula which worked on color. > > please see attachment. > > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > 9

$$Excel-Macros$$ Please help

Dear Experts please hep me for a formula which worked on color. please see attachment. -- <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.

Re: $$Excel-Macros$$ Please help

case wen u write =Sum(A2:A20 immediately press F4 the formula will convert to =SUM($A$2:$A$20 and then continue let me know if it works. From: D M Sukumar To: excel-macros@googlegroups.com Sent: Sat, 29 January, 2011 11:03:37 PM Subject: RE: $$Excel-Macros

Re: $$Excel-Macros$$ Please help

", well, the current cell is column "B", so when you copy it to column C, the formula changes to "C".. does that help? Paul ____________ From: D M Sukumar To: excel-macros@googlegroups.com Sent: Sat, January 29, 2011 12:33:37 PM Subject: RE:

RE: $$Excel-Macros$$ Please help

Hai groups, Can you tell me what is the use of $ sign excel And can you give some examples please;;; Thank you From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ Please help

use sumif check the attachment On Sat, Jan 29, 2011 at 9:43 PM, sudhir kumar wrote: > Dear Experts > > > Please help see my attachement and help me. > > > thanking you > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > > P think Bef

$$Excel-Macros$$ Please help

Dear Experts Please help see my attachement and help me. thanking you -- <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Sudhir Verma Asstt. Mngr. A/c's P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!

Re: $$Excel-Macros$$ Please help to get result through Formule

Hi Find the attachment. Thanks & Regards Thamu On Thu, Jan 27, 2011 at 3:04 PM, Born to Win wrote: > Hello Expert, > > In Attached Sheet i am making a tracker For Attrition In first summary > sheet i have to show Band with Colour corresponding to his Last Dated > Status. > > Please help me to

Re: $$Excel-Macros$$ Please help to get result through Formule

Hi CS, If you want to color the band. You can Conditional Formatting to get the result. Regards Umesh On Thu, Jan 27, 2011 at 3:04 PM, Born to Win wrote: > Hello Expert, > > In Attached Sheet i am making a tracker For Attrition In first summary > sheet i have to show Band with Colour correspon

$$Excel-Macros$$ Please help to get result through Formule

Hello Expert, In Attached Sheet i am making a tracker For Attrition In first summary sheet i have to show Band with Colour corresponding to his Last Dated Status. Please help me to get that Result on Summary sheet through formula . Thanks, CS --

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

Dear Sudhir, Just would like to mention that the cells should be in date format, only then this function will work. Regards, Anubhav On Wed, Jan 19, 2011 at 2:59 PM, Manoj kumar wrote: > use either of them :- > > =(B1-A1)+1 > =DATEDIF(A1,B1,"d")+1 > > > Regards, > Manoj Kumar > > > On Wed, J

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

use either of them :- =(B1-A1)+1 =DATEDIF(A1,B1,"d")+1 Regards, Manoj Kumar 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-10

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

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

$$Excel-Macros$$ Please help me

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 Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.

Re: $$Excel-Macros$$ Please help on the formula

Hi Noorian/ Team, I got succeded in making up the formula...:) please find the attached excel sheet Thanks , psreevi...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips t

Re: $$Excel-Macros$$ Please help on the formula

> > Hi Noorian/ Team, > I got succeded in retrieving data by using dr as branch ( used indirect function only )but failed when trying to give sr as branch . could any one can fix the issue.. only by using indirect function only... it should retrieve data based on branch . Please find the atta

Re: $$Excel-Macros$$ Please help on the formula

Hi Noorain, Here we use only vlookup i am worng or right, On Fri, Dec 24, 2010 at 5:00 PM, NOORAIN ANSARI wrote: > Dear Poojari, > > Please see attachments.. > > Thanks, > Noorain Ansari > > On Fri, Dec 24, 2010 at 12:24 AM, poojari sreevijay < > psreevi...@gmail.com> wrote: > >> Hi Team, >

Re: $$Excel-Macros$$ Please help on the formula

Dear Poojari, Please see attachments.. Thanks, Noorain Ansari On Fri, Dec 24, 2010 at 12:24 AM, poojari sreevijay wrote: > Hi Team, > > Please advise on the formula in H.O Sheet .. > > I am unable to get the data in B4. > > > > -- > psreevi...@gmail.com > > -- > > --

$$Excel-Macros$$ Please help on the formula

Hi Team, Please advise on the formula in H.O Sheet .. I am unable to get the data in B4. -- psreevi...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

Re: $$Excel-Macros$$ Please help in this Matter

Check if this works for you. Regards, Manoj Kumar On Tue, Dec 21, 2010 at 1:08 PM, Rohan Young wrote: > Hi Experts, > > Please help me out the problem is if i check my status from master sheet > for knowing how many projects are under process, when i select the statusfrom > the drop down lis

$$Excel-Macros$$ Please help in this Matter

Hi Experts, Please help me out the problem is if i check my status from master sheet for knowing how many projects are under process, when i select the statusfrom the drop down list, why dont all releated figures comes out. e.g. if i select under process all the under process project details sh

Re: $$Excel-Macros$$ Please help regard this question

=IF(A1 >= A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)& " Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & DAY(A1) - DAY(A2) & " Day(s) Left", "Please check the date(s)") On Mon, Nov 15, 2010 at 11:14 AM, Manjunath C wrote: > Excellent one,,,its working,,

Re: $$Excel-Macros$$ Please help regard this question

Excellent one,,,its working Is it possbile , the result should be 0 , if i give same dates for both. On Fri, Nov 12, 2010 at 9:53 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > =IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & > IF(MONTH(A1) - MO

Re: $$Excel-Macros$$ Please help regard this question

=IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check the date(s)") this will supress if year/month/day = 0 in the expansio

Re: $$Excel-Macros$$ Please help regard this question

=IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check the date(s)") On Fri, Nov 12, 2010 at 4:19 PM, Jai wrote: > THANKS A LO

Re: $$Excel-Macros$$ Please help regard this question

THANKS A LOST EXPERTS On Fri, Nov 12, 2010 at 3:59 PM, SAJID MANSOOR wrote: > Very simple! Good > > > On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI > wrote: > >> Dear Jai... >> >> Please see attachment.. >> >> =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, >> "&TEXT((D5-D6),"dd")&

Re: $$Excel-Macros$$ Please help regard this question

Very simple! Good On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI wrote: > Dear Jai... > > Please see attachment.. > > =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, > "&TEXT((D5-D6),"dd")&" DAYS" > Thanks, > Noorain > On Thu, Nov 11, 2010 at 9:47 PM, Jai wrote: > >> Dear Groups >

Re: $$Excel-Macros$$ Please help regard this question

Dear Jai... Please see attachment.. =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, "&TEXT((D5-D6),"dd")&" DAYS" Thanks, Noorain On Thu, Nov 11, 2010 at 9:47 PM, Jai wrote: > Dear Groups > > First Cell > > 20/12/2011 > > Secound Cell > > 12/11/2010 > > R

Re: $$Excel-Macros$$ Please help regard this question

Hey Jai, Supposing the dates are in cells A1 and A2, you can use the following in cell A3: =DATEDIF(A2,A1,"y")&IF(DATEDIF(A2,A1,"y")>1," years ,"," year ,")&DATEDIF(A2,A1,"ym")&IF(DATEDIF(A2,A1,"ym")>1," months ,"," month ,")&DATEDIF(A2,A1,"md")&IF(DATEDIF(A2,A1,"md")>1," days left."," day left."

$$Excel-Macros$$ Please help regard this question

Dear Groups First Cell 20/12/2011 Secound Cell 12/11/2010 Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT DEAR GROUP MEMBER PLEASE HELP ME, I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL Required Results 1 YEAR ,1 MONTH ,8 DAYS LE

Re: $$Excel-Macros$$ Please help

ble to devote that much > time. :( > > Best Regards, > DILIPandey > > > > On Tue, Oct 12, 2010 at 6:13 PM, rajasekhar praharaju < > rajasekhar.prahar...@gmail.com> wrote: > >> >> >> -- Forwarded message -- >> From:

Re: $$Excel-Macros$$ Please help

< rajasekhar.prahar...@gmail.com> wrote: > > > -- Forwarded message -- > From: rajasekhar praharaju > Date: Tue, Oct 12, 2010 at 5:49 PM > Subject: Re: $$Excel-Macros$$ Please help > To: Dilip Pandey , excel-macros@googlegroups.com > > > hi Dilip, >

Re: $$Excel-Macros$$ Please help

hi Dilip, firstly i will be copying the pivot table from task distribution sheet. Row Labels Sum of # of no hits DEEPTI 45 LAKSHMI 35 NIKHIL 46 PUSHPA 15 RAVI 7 SAI 35 VENKAT 46 ARVIND 21 Grand Total 250 this part from task distribution sheet and click on extension bar (+) to get th

Re: $$Excel-Macros$$ Please help

Dear Rakasekhar. I am not able to understand your problem actually... :( How you are assigning the names against tasks ? I believe creating a pivot table and then using "Show Pages" option you can assign the tasks to different individuals. Please explain further if you need some other solution.

Re: $$Excel-Macros$$ Please help

could you please assist me in this concern .please actually if any batch is pending using vlookup i used to find their respective names how is this possible through sumif please suggest . On Fri, Oct 8, 2010 at 11:13 AM, SUMIT VYAS wrote: > Dear Rajasekhar > > > Please use u Sumif Formulas. >

Re: $$Excel-Macros$$ Please help

Dear Rajasekhar Please use u Sumif Formulas. Regards Sumit Vyas On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju < rajasekhar.prahar...@gmail.com> wrote: > > > hi Excel Guru, > > > Please assist me in this concern . > > > Attached are two sheets Task distribution orginal and other she

Re: $$Excel-Macros$$ Please Help

please check the attached workbook On Mon, Sep 27, 2010 at 11:02 PM, hemant shah wrote: > Hi Team, > Can you please help on the attached file. > I have explained my query in the attached sheet. > Regards, > Hemant Shah --

$$Excel-Macros$$ Please Help

Hi Team, Can you please help on the attached file. I have explained my query in the attached sheet. Regards, Hemant Shah -- Forwarded message -- From: Date: Mon, Sep 27, 2010 at 9:25 PM Subject: Book1.xls To: hemanthin...@gmail.com Please do not print this email unless it i

Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA

Dear Dilipji, Thank you very much, It is working, but one problem It showing error when nothing is entered, I have tried to insert isserror formula, but not able insert it. if possible please revise my file. again thank you very much for your kind help On Sat, Jul 24, 2010 at 9:24 AM, Dilip Pande

Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA

Thanks Rahul, No doubt, "concatenate" and "&" will do the task but for that we need to have a column on both d locations n we also need to check if this is feasible. But anyways both the ways are ok n there are other ways as well :) thx, DILIPandey On 7/24/10, Rahul Gandhi. wrote: > I Think in

Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA

I Think in particular this scenerio we have one more function of "Concatenate" or "&". that also helps us to do the same, at the other hand this formula is also very suitable for so many conditions.. Thanks again sir. On Jul 23, 6:33 pm, Dilip Pandey wrote: > Hi Hari, > > I have achieved the

$$Excel-Macros$$ Please help - VBA book

I am a beginner of VBA in Excel. Can anybody tell me good VBA book which will help me to learn it from scratch? Book should be simple to study. Thanks -- -- Some important links for excel users: 1. Follow us on TWITT

Re: $$Excel-Macros$$ Please Help me its urgent//Not able to apply count if function in Attached sheet.

Thanks for ur support sumit. Thanks, Chandrabhan Singh On Tue, May 11, 2010 at 7:19 PM, sumit kumar wrote: > Dear Chandra > > here is the attached sheet probably you were looking for. > > Sumit > > On Tue, May 11, 2010 at 2:54 PM, Born to Win wrote: > >> Hi All, >> >> Please Help me its urge

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

can any one help me out i m waiting for your response ..otherwise i have to apply these thing in all thousand company and its a time taking On Wed, May 5, 2010 at 9:57 AM, Vikas Chouhan wrote: > Harry.. > > > 2003 format > > > On Tue, May 4, 2010 at 10:11 AM, Harpreet Singh Gujral < > harpreetgu

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

Sidhantha, Is it possible for you to provide Excel 2003 version Harry On May 3, 4:33 pm, sidhantha suchit wrote: > hi > > attach one of the sheet and thereis 1000 of such kind of sheet were i have > to do this wrk please help me. > On Mon, May 3, 2010 at 9:36 AM, Rahul Gandhi. wrote: > > > > >

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

Can you please give me the example so that we can atleast try to help you out with query. On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know its my duty but can if any one he

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

Can you please give me the example so that we can atleast try to help you out with query. On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know its my duty but can if any one he

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

Sidhantha, I can give it a try, as i am also studying some things related to Stock Market... Let me know Harry On May 2, 6:58 pm, sidhantha suchit wrote: > hi > > sir > > I m new to this group right now i m doing a project on stock market and i > have to do lot of calculation ,I know it

$$Excel-Macros$$ Please help me

hi sir I m new to this group right now i m doing a project on stock market and i have to do lot of calculation ,I know its my duty but can if any one help me its reduce my task because i have to apply in 1000 BSE listed company . what i have to calculate Volatility (daily) Jump in script Mean R

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

Hi Sudhir, Would it be possible for you to attach both the sheets, i will try to work on it. If possible, please specify which sheet would serve as the master against which the other sheet will be compared. Cheers! Harry On Tue, Apr 27, 2010 at 9:25 PM, sudhir kumar wrote: > Thanks Harpreetj

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

Thanks Harpreetji, for your valuable solution I have an another problem, I have two excel sheets, both are having same format, and contain huge amount of data. now i want to compare them, old one with the new one. and i want to find out which data is deleted, which one is added, and w

RE: $$Excel-Macros$$ please help me for Excel Conditional formula with example

Huh? Date: Mon, 26 Apr 2010 21:18:44 -0700 Subject: $$Excel-Macros$$ please help me for Excel Conditional formula with example From: vikask...@gmail.com To: excel-macros@googlegroups.com Dear All, Please help me for excel condition formula's, pls send formula with example ...pls

$$Excel-Macros$$ please help me for Excel Conditional formula with example

Dear All, Please help me for excel condition formula's, pls send formula with example ...pls it's a urgent. One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

Hi Sudhir,   Try this,,, hope u r talking abut grouping and ungrouping       Rows("1:2").Select     Selection.Rows.Group --- On Sat, 24/4/10, sudhir wrote: From: sudhir Subject: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel To: "M

Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

hi harpreet ji , thank u very much , thats the thing i want -- Regards- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- -- Some important links for exce

$$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel

Dear friends, I want a macro for hide and unhide the sub headings in excel, like we can do in MS project with +mark, when we click on + symbol it highlights the subtask available in that particular task. Is it possible??., pleas help me --

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

Singh > > Sent via BlackBerry Wireless > > On Wed, Mar 31, 2010 at 7:52 AM, Dave Bonallack > wrote: > > > > >  Hi Harmet, > > MUCH shorter than mine! Very good. > > Does need to be entered with Ctrl+Shift+Enter > > Regards - Dave. > > > -

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

red with Ctrl+Shift+Enter > Regards - Dave. > > -- > From: harmeet.hew...@gmail.com > Date: Wed, 31 Mar 2010 05:56:49 +0530 > Subject: Re: $$Excel-Macros$$ Please help In seperating alphabets and > numbers from a cell > > To: excel-macros@goo

RE: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

Hi Harmet, MUCH shorter than mine! Very good. Does need to be entered with Ctrl+Shift+Enter Regards - Dave. From: harmeet.hew...@gmail.com Date: Wed, 31 Mar 2010 05:56:49 +0530 Subject: Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell To: excel-macros

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

","o","p","q","r","s","t","u","v","w","x","y","z"},MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),100)&"abcdefghijklmnopqrstuvwxyz"))-1) &g

RE: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

,"g","h","I","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},MID(A1,MIN(SEARCH(

RE: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

meone else can help you remove the trailing non-numeric characters. Regards - Dave, Date: Tue, 30 Mar 2010 13:55:06 +0530 Subject: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell From: abhidha.di...@gmail.com To: excel-macros@googlegroups.com Dear All I am s

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

Hello Dear, Following Is the attached macro for your problem. Hope it will Help Happy To help :) Shyam On Tue, Mar 30, 2010 at 1:55 PM, Abhidha Dixit wrote: > Dear All > > I am seeking for the reply of one queryy > how to seperate alphats and no. > eg: jdsdnc2123asdd > iofruif687

$$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

Dear All I am seeking for the reply of one queryy how to seperate alphats and no. eg: jdsdnc2123asdd iofruif68732fnvv thnks in advance regards Abhidha -- -- Some important links for excel users: 1. Follow us o

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

the contents meet the criteria. > > (if a1 > H1 then H1 = a1) > (if a2 < H2 then H2 = a2) > > let me know if you need help with the change events. > > Paul > > > From: Sach1810 > To: MS EXCEL AND VBA MACROS > Sent: Fri, March 5, 2010 3:39:

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

events. Paul From: Sach1810 To: MS EXCEL AND VBA MACROS Sent: Fri, March 5, 2010 3:39:40 AM Subject: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data Hi, I have two cells lets say a1 and a2 b

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

Hello Dear Have you Tried MAX() Please let me know,if more help required. Hope it will Help Happy To Help :) Shyam On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 wrote: > Hi, > > I have two cells lets say a1 and a2 both of which are continually > updating from a live feed. I would like to be abl

Re: $$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

Can you send an example file ? That would help to understand better. Thanks, On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 wrote: > Hi, > > I have two cells lets say a1 and a2 both of which are continually > updating from a live feed. I would like to be able to track what the > highest number of a1

$$Excel-Macros$$ Please help me print a the highest number that appears from a cell with continuously streaming data

Hi, I have two cells lets say a1 and a2 both of which are continually updating from a live feed. I would like to be able to track what the highest number of a1 has been and what the lowest number of cell a2 has been. Your help would be much appreciated as I am new to programming Many Thanks Sa

Re: $$Excel-Macros$$ PLEASE HELP

hi sudhir check this addin and use formula =num2text(a1) a1 is cell having number Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 26, 2010 at 4:11 PM, sudhir kumar wrote: > Hi Dear all, > > Please help me fo

$$Excel-Macros$$ PLEASE HELP

Hi Dear all, Please help me for below formula. 1. how to convert numbers in text. 2. Example 2000Two thousands when i m change the number the text changed automatically. -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -

Re: $$Excel-Macros$$ Please help - consolidate all shets in main shet

e: >>> >>>> Thanx Ashish…its work..thanx again >>>> >>>> >>>> >>>> - Umesh Matkar >>>> >>>> >>>> >>>> *From:* excel-macros@googlegroups.com [mailto: >>>> excel-mac...@go

Re: $$Excel-Macros$$ Please help - consolidate all shets in main shet

m [mailto: >> excel-mac...@googlegroups.com] *On Behalf Of *ashish koul >> *Sent:* Saturday, February 06, 2010 7:57 PM >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Please help - consolidate all shets in >> main shet >> >>

Re: $$Excel-Macros$$ Please help - consolidate all shets in main shet

; > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *ashish koul > *Sent:* Saturday, February 06, 2010 7:57 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Please help - consolidate all shets in >

RE: $$Excel-Macros$$ Please help

Ahmedhonest Sent: 08/February/2010 11:30 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help Dear All Please find the attach file where i have 2 sheets in he sheet2 i need the formula for extracting the values from sheet1. I need the values withou using vlookup formula

Re: $$Excel-Macros$$ Please help to apply formula

C2)) > > Now, if you only want to apply "proper" to the first word, then > it's just a matter of where you place the () > =PROPER(TRIM(A2)) & " " & TRIM(B2) & " " & TRIM(C2) > > > Paul > > -- > *Fr

$$Excel-Macros$$ Please help

Dear All Please find the attach file where i have 2 sheets in he sheet2 i need the formula for extracting the values from sheet1. I need the values withou using vlookup formula. please relply me to the following email addresses: ahmedhon...@gmail.com AND abawa...@solexplus.net $10,000 Thanks

Re: $$Excel-Macros$$ Please help to apply formula

"&B2&" "&C2)) or: =PROPER(TRIM(A2)&" "&TRIM(B2)&" "&TRIM(C2)) Now, if you only want to apply "proper" to the first word, then it's just a matter of where you place the () =PROPER(TRIM(A2)) & " " & TRIM(

$$Excel-Macros$$ Please help to apply formula

Hi all, How to apply more than two functions in a singal formual., For ex:- i have to *concatenate* data and make it *trim *and *proper.* Appreciate your soonest response. Thank you all. -- Suhas -- -- Some imp

RE: $$Excel-Macros$$ Please help - consolidate all shets in main shet

Thanx Ashish.its work..thanx again - Umesh Matkar From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, February 06, 2010 7:57 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help - consolidate

RE: $$Excel-Macros$$ Please help - consolidate all shets in main shet

Thank you very very much. Its working.Thanx From: ayush jain [mailto:jainayus...@gmail.com] Sent: Saturday, February 06, 2010 8:37 PM To: excel-macros@googlegroups.com Cc: matkarum...@gmail.com Subject: Re: $$Excel-Macros$$ Please help - consolidate all shets in main shet Dear Umesh

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

hi Subhash where is file ? On 01/02/2010, Dilip Pandey wrote: > Hi Subhash, > > You have forgot to attach the files. Please attach the file and explain > your query as well. Thanks. > > Best Regards, > -- > DILIP KUMAR PANDEY > MBA-HR,B Com(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gm

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

Hi Subhash, You have forgot to attach the files. Please attach the file and explain your query as well. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, Feb 1, 2010 at 4:15 PM,

$$Excel-Macros$$ Please help me fourmula

Dear All, please give me count fourmula in thes sheet -- Subhash Pratham Mumbai Education Initiative 9870914252 -- -- Some important links for excel users: 1. Follow us on TWITTER for

<    1   2   3   4   >