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

Thanksa ton Sourav. You kind help is highly appreciated. On Wed, Aug 3, 2016 at 7:46 PM, sourav devrani wrote: > please use this file. > i have change some little formula here you can use this file. > > Regards > Sourav Devrani > > On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani < > souravdevrani

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

please use this file. i have change some little formula here you can use this file. Regards Sourav Devrani On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani wrote: > please see the attached file. > > On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman > wrote: > >> Is there any one who can solve this,

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

please see the attached file. On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman wrote: > Is there any one who can solve this, please ? > > On Aug 2, 2016 23:38, "Jayanta Barman" wrote: > >> Hello Excel experts, >> >> I have a small problem in excel. Please help me in resolving this. >> >> Problem:

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

Is there any one who can solve this, please ? On Aug 2, 2016 23:38, "Jayanta Barman" wrote: > Hello Excel experts, > > I have a small problem in excel. Please help me in resolving this. > > Problem: I have a set of products launched at different years with their > revenue figures. I want to crea

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

Dat's Cool Vaibhav. Thanks. On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth wrote: > > Very Nice... Mr.Vabz > > On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: > >> Suppose you have value in cell A1 then type follo. formula in A2 & dont >> press enter & press F9, you will get r

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

Very Nice... Mr.Vabz On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: > Suppose you have value in cell A1 then type follo. formula in A2 & dont > press enter & press F9, you will get result in curly bracket, after = sign > enter CONCATENATE( & press enter to get result > > > =T

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

Suppose you have value in cell A1 then type follo. formula in A2 & dont press enter & press F9, you will get result in curly bracket, after = sign enter CONCATENATE( & press enter to get result =TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),

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

; > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > *From:* Gaurav Devrani >

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

bruary 26, 2015 11:55 AM >Subject: Re: $$Excel-Macros$$ Please help me Urgent > > > >Thanks Paul for your quick reply. Yes I was also trying to create a macro but >Just wanted to confirm before, if that's possible in excel functions. No >worries. I really appreciate your

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

Thanks Paul for your quick reply. Yes I was also trying to create a macro but Just wanted to confirm before, if that's possible in excel functions. No worries. I really appreciate your quick response once again. Thank you. Regards Gaurav Devrani On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner

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

I don't believe you'll be able to do that with standard Excel functions. you can create a CUSTOM function using VBA and use it like an Excel function. In your case, you need to process each character and "switch" the case. the problem is, within a standard Excel function, there's no way to "proces

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Hi I am not sure of this. Thx On Wed, Apr 30, 2014 at 3:34 PM, renuka chari wrote: > Dear Sir thanks alot... > > i have a one doubt i.e my client places they are using Lotus note we are > used to send this dashboard to my client place is this macro would be work > on that place. > > please su

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear Sir thanks alot... i have a one doubt i.e my client places they are using Lotus note we are used to send this dashboard to my client place is this macro would be work on that place. please suggest. On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote: > > Hi > > You can do so b

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear Sir, countif function creating more violation for huge data range. is there any possible to overcome or use any other function. please guide me... thanks... On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote: > > Dear sir, > > thank you so much.your

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear sir, thank you so much.your given a great help.. On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote: > > Hi > > PFA alternate method using formula & help sheet. > > Thanks > > > On Tue, Apr 29, 2014 at 8:57 PM, renuka chari > > wrote: > >> Dear sir, >> >> Thank you so

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear sir, Thank you so much for your time and effort into problem. my dashboard having huge no of sheets and if i make pivot sheet then my workbook size is increasing more i was applied your formula earlier itself. but i need even better solution. and my dash board data range is not constant i

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Its not possible to do without any help column. Another way out is shown in attached file. Ref col E & F. Thx On Tue, Apr 29, 2014 at 2:34 PM, renuka chari wrote: > Dear sir, > > i dont want to use pivot. i need only formula for offset or index is it > possible... > > On Tuesday, 29 April 201

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear sir, i dont want to use pivot. i need only formula for offset or index is it possible... On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote: > Hi > > You can do using Pivot Table, see attached file. > > >1. In the Pivot Table, click the drop down arrow in the RowLabels >fi

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Hi You can do using Pivot Table, see attached file. 1. In the Pivot Table, click the drop down arrow in the RowLabels field heading. 2. In the pop-up menu, click Value Filters, then click Top 10 & change it to 5. You can sort on Descending on Output by going thru More Sort option un

Re: $$Excel-Macros$$ please help me GRK

Dear GRKNAIDU, Please use this formula in the Bonus Qty column and copy down: =IF(MOD(J4,100)=0,(J4/100)*20,ROUNDDOWN(J4/100,0)*20) Regards, Aindril On Sat, Mar 2, 2013 at 5:33 PM, GRKRISHNA NAIDU wrote: > Dear all > > Will you please help to get the formula > > > for an example in attachment

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's. Yes, but in the combobox "Save as type:" I don't have PDF format. Best regards, *Constantin ZAMFIR* Service engineer, Euritmic Grup SRL <http://www.euritmicgrup.ro/> - Roma

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

Yes, but in the combobox "Save as type:" I don't have PDF format. Best regards, *Constantin ZAMFIR* Service engineer, Euritmic Grup SRL - Romania Mobil: +40 741-105-012 (Orange) Mobil: +40 726-226-021 (Cosmote) *Before printing this e-mail please consider environmen

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

Hi, Insted of printing with the help of Nitro PDF you can save file as PDF. Rgds//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Constantin Zamfir Sender: excel-macros@googlegroups.com Date: Fri, 19 Oct 2012 10:35:38 To: Reply-To: excel-macros@googlegroups.com Sub

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

groups.com Subject: Re: $$Excel-Macros$$ please help me to solve this question it's very urgent Hi team, Thanks so much for help me and give best to best Suggestions Thanks Pravesh Kumar On 8/30/12, Kuldeep Singh wrote: Dear Preavesh, 04 solutions of you. for any query please

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi amresh, Thanks! for help me On 8/30/12, Amresh Maurya wrote: > Hi Pravesh, > > Find the attached solved file. > > =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) > > Reagrds > Amresh > > On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish < > vaishpriyanka2...@gmail.com> wrote: > >> Hi Pra

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Pravesh, Your most welcome. Regards, Kuldeep Singh On Fri, Aug 31, 2012 at 11:39 PM, PRAVESH KUMAR wrote: > Hi team, > > > Thanks so much for help me and give best to best Suggestions > > Thanks > Pravesh Kumar > > > On 8/30/12, Kuldeep Singh wrote: > > Dear Preavesh, > > > > 04 solutions

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi team, Thanks so much for help me and give best to best Suggestions Thanks Pravesh Kumar On 8/30/12, Kuldeep Singh wrote: > Dear Preavesh, > > 04 solutions of you. for any query please see attachment. > > =LOOKUP(H3,$C$3:$D$9) > =VLOOKUP(H3:H6,$C$3:$D$9,2,0) > =VLOOKUP(H3,$C$3:$D$9,2,0) > =

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

I see you have answers but why is YOUR request more URGENT than any other? Also, use a meaningful subject line and explain your question in the email and in the file. etc. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: PRAVESH K

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Pravesh, Enclosed herewith your query solu Regards, Gawli Anil On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh wrote: > > Dear Preavesh, > > 04 solutions of you. for any query please see attachment. > > =LOOKUP(H3,$C$3:$D$9) > =VLOOKUP(H3:H6,$C$3:$D$9,2,0) > =VLOOKUP(H3,$C$3:$D$9,2,0) > =IF

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Preavesh, 04 solutions of you. for any query please see attachment. =LOOKUP(H3,$C$3:$D$9) =VLOOKUP(H3:H6,$C$3:$D$9,2,0) =VLOOKUP(H3,$C$3:$D$9,2,0) =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) Regards, Kuldeep Singh On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya wrote: > Hi Praves

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi Pravesh, Find the attached solved file. =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) Reagrds Amresh On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish < vaishpriyanka2...@gmail.com> wrote: > Hi Pravesh, > > =VLOOKUP($H3,$C$3:$D$9,2,0) > > I think this formula would solve

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi Pravesh, =VLOOKUP($H3,$C$3:$D$9,2,0) I think this formula would solve your question. On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR wrote: > Hi Team, > > please help me to solve this question it's very urgent > > > waiting your response > > > > -- > > Thanks & Regards > > Prav

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Mr. Pravesh See the attached file and kindly refer the forum rules, the subject line must be clear regarding your query Ashish On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR wrote: > Hi Team, > > please help me to solve this question it's very urgent > > > waiting your response > > > > -- > >

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

Thanks Deba. Its very nice even before using it I never know that Excel could do all these stuff so nicely. Thanks again Dear. On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan wrote: > Dear Mangesh, > > To create this calendar in the range B2:H9, follow these steps: > > > 1. Select B2:H2 and merge t

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

Dear Mangesh, To create this calendar in the range B2:H9, follow these steps: 1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge & Center. 2. Enter a date into the merged range. The day of the month isn’t important. 3. Enter the abbreviated day names in the range B3:H3.

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

Please tell us so that we can edit and learn it. How to make ? calender_Simple.xls file On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI wrote: > Dear Manoj, > > Please find attached simple Calender. > > You can create it simply. > > On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar > wrote: > >> De

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

Dear Manoj, Calender in excel can be prepared by Array formula too, its purely full array for whole the months and years. =IF(MONTH(DATE(YEAR(C5),MONTH(C5),1))<>MONTH(DATE(YEAR(C5),MONTH(C5),1)-(WEEKDAY(DATE(YEAR(C5),MONTH(C5),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(C5),MONTH(C5),1

RE: $$Excel-Macros$$ Please help me.

ros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help me. Dear Suman, It is working fine with table, Pls see the attached sheet. -- Thanks & regards, Noorain Ansari www.noorainansari.com <http://www.excelmacroworld.blogspot.com> www.excelmacroworld.blogspot.com On Wed, Jul 11, 20

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

Dear Suman, It is working fine with table, Pls see the attached sheet. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jul 11, 2012 at 1:43 PM, Suman wrote: > Hi, > Guru Ji, > Its not working when i applying in table. Please guide...!! > > R

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

Hi, Guru Ji, Its not working when i applying in table. Please guide...!! Regards, @Suman Send on the move with Galexy y. On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI" wrote: > Dear Manoj, > > You can also try > =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found") > > On Wed, Jul 11, 2012 at 1:01

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

Thanks Noorain Ji... its working.. On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI wrote: > Dear Manoj, > > You can also try > =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found") > > On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar > wrote: > >> Dear Expert. >> >> i have 2 Coll A1 & B2 >> >> A

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

Dear Manoj, You can also try =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found") On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar wrote: > Dear Expert. > > i have 2 Coll A1 & B2 > > A1 Contain (Foto Fast Elec) > B1 Contain (Fast) > > I want khow B1 is in A1 or not... > > Regard > Manoj > > -- >

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

Hi, use below formula =find(B1,A1) Regards Amresh On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar wrote: > Dear Expert. > > i have 2 Coll A1 & B2 > > A1 Contain (Foto Fast Elec) > B1 Contain (Fast) > > I want khow B1 is in A1 or not... > > Regard > Manoj > > -- > FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

t; See attached that eliminates the need for Hyperlinks > Look in the ThisWorkbook module and the sheet module > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Avinash Patil > Sent: Monday, January 30, 2012 9:09 AM > To: excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

yes dilip, i guess u r right. i want the results as per the results highlighted in red border. and hyperlink format in red font. regards, Avinash On Sun, Jan 29, 2012 at 12:31 PM, Dilip Pandey wrote: > Hi Avinash, > > Not entirely getting your point. > Please confirm if you need following <

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

Hi Avinash, Not entirely getting your point. Please confirm if you need following < which I can understand per your post> :) 1) Following results as per Date in first field < this you have already attached> DateTotal Product Actual PriceTotal Number Of ProductsGrand Total She

Re: $$Excel-Macros$$ PLEASE HELP ME

You need to tell us what you want and why This cell _on this sheet___in this file_ needs to come from This cell _on this sheet___in this file_ and WHY Don Guillett SalesAid Software dguille...@gmail.com From: Chandra Singh Bora Sent: Friday, December 09, 2011

Re: $$Excel-Macros$$ Please help me(Combo box)

Dear Friends Thank your very much for your great reply. may u define this formula. I can not find any source for *Groups* . I am using that other place that function is not working. Thanks again Sanjay Kumar Maurya On Thu, Aug 4, 2011 at 5:18 AM, XLS S wrote: > Hey Sanjay > > Try to use In

Re: $$Excel-Macros$$ Please help me(Combo box)

Hey Sanjay Try to use Indirect Functionplease find the attachment On Wed, Aug 3, 2011 at 9:02 PM, Sanjay Maurya wrote: > Dear Frd > > Thanks for your reply and solution but I have more data so pivot table > is not possible for it. if u have any easy format please tell me. > > T

Re: $$Excel-Macros$$ Please help me(Combo box)

Dear Frd Thanks for your reply and solution but I have more data so pivot table is not possible for it. if u have any easy format please tell me. Thanks Sanjay Kumar Maurya On 8/3/11, sreejith k.s wrote: > hi Sanjay, > > just see whether this helps...i created a pivot according to my > understa

Re: $$Excel-Macros$$ Please help me(Combo box)

Hi, Please find the attached sheet with solution. Thanks Rupesh Kr. On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote: > Hi frds > > Please help me. > > -- > ***Thanks > Sanjay Kumar Maurya* > > -- > > -- > Some

Re: $$Excel-Macros$$ Please help me(Combo box)

hi Sanjay, just see whether this helps...i created a pivot according to my understanding of the quwestion...just get back to me if it is not enough On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote: > Hi frds > > Please help me. > > -- > ***Thanks > Sanjay Kumar Maurya* > > -- > > ---

Re: $$Excel-Macros$$ Please help me(Combo box)

see if it helps On Wed, Aug 3, 2011 at 11:48 AM, Sanjay Maurya wrote: > Hi frds > > Please help me. > > -- > ***Thanks > Sanjay Kumar Maurya* > > -- > > -- > Some important links for excel users: > 1. Follow us on TW

Re: $$Excel-Macros$$ please help me Urgent

Hi Sukumar, I am not sure whether this is what you are looking for.. Have a look in the attached file whether it suits your requirement. --- *Sixthsense **:) Man of Extreme & Innovative Thoughts :)* On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote: > Hi, > > Students English maths sceience

Re: $$Excel-Macros$$ please help me Urgent

hi sukumar, please find attached. regards, saber On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote: > Hi, > > Students English maths sceience Grades > suresha 45 80 90 90-100 A > srinivas 25 36 60 80-90 b >

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

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

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 it'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: "MS EXCEL AND VBA 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

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

Decided to go to the GoogleGroups site so that I can see the whole discussion thread. I'll explain in detail. To create a change event: Right-click on the sheet "tab"and select "View Code" At the top of the editor "code" window is a set of pull-downs. In the left pull-down, select "WorkSheet". I

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

You could: store initial values in a hidden cell. Create a change event for the worksheet that compares the cell contents to the hidden cells and update if 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. Pa

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

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,