RE: $$Excel-Macros$$ VBA Code Related Question

2012-10-18 Thread Asa Rossoff
Hi Amar, I examined your file, and it seems that ALL of the VBA objects are needed in your new workbook, even though you are only using certain chart types. Also needed is the icons sheet (which may be hidden) for everything to work properly. What MAY be an alternative is to allow it to

$$Excel-Macros$$ Re: Hard to find Status for me...

2012-10-18 Thread Vabz
hi what is logic, i am not able to get it. Please explain. Rgds//Vabs On Thursday, October 18, 2012 11:18:23 AM UTC+5:30, Manoj Kumar wrote: Dear Expert. Please help me.. File attached below.. Regard Manoj -- Join official facebook page of this forum @

$$Excel-Macros$$ Fwd: Need formula to update status

2012-10-18 Thread Manoj Kumar
-- Forwarded message -- From: Manoj Kumar manoj.11...@gmail.com Date: Thu, Oct 18, 2012 at 12:29 PM Subject: Need formula to update status To: excelvbacli...@googlegroups.com Dear Expert, Please Find the attachment.. Please provide me a formula to update status in coll F

Re: $$Excel-Macros$$ VBA Code Related Question

2012-10-18 Thread amar takale
Dear Asa, Actually I want to sparklines also piechart,barchart in single cell in excel 2003 (I Used this version) So I will try it to export only certain chart.There are any option in excel 2003 for sparklines,piechart,barchart in single cell then I will not try to export chart from other file

$$Excel-Macros$$ Re: Need formula to update status

2012-10-18 Thread Vabz
Hi PFA.. Cheers.. Rgds//Vabs On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote: -- Forwarded message -- From: Manoj Kumar manoj...@gmail.com javascript: Date: Thu, Oct 18, 2012 at 12:29 PM Subject: Need formula to update status To:

Re: $$Excel-Macros$$ Re: Need formula to update status

2012-10-18 Thread Manoj Kumar
Thanks On Thu, Oct 18, 2012 at 1:05 PM, Vabz v...@vabs.in wrote: Hi PFA.. Cheers.. Rgds//Vabs On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote: -- Forwarded message -- From: Manoj Kumar manoj...@gmail.com Date: Thu, Oct 18, 2012 at 12:29 PM

RE: $$Excel-Macros$$ VBA Code Related Question

2012-10-18 Thread Asa Rossoff
Sparklines in-cell charting was added as a native feature in Excel 2010, although it is not as sophisticated as the addin you are using. I am not an expert on the add-in, in fact, it looks great, but I have never used it. For help on the proper way to use it I recommend you check the

Re: $$Excel-Macros$$ Re: Pls help me on this.

2012-10-18 Thread अनिल नारायण गवली
Thanks Paul Schreiner . Thank u very much. Cheers... REgards Gawli Anil On Wed, Oct 17, 2012 at 12:22 AM, Paul Schreiner schreiner_p...@att.netwrote: first: a little Group Etiquette: Being in the United States, I'm in a different time zone than many people who participate in these forums.

Re: $$Excel-Macros$$ VBA Code Related Question

2012-10-18 Thread amar takale
Thanky very much for great guidelines for me.This is very useful for solution Thanks again.. On Thu, Oct 18, 2012 at 1:20 PM, Asa Rossoff a...@lovetour.info wrote: Sparklines in-cell charting was added as a native feature in Excel 2010, although it is not as sophisticated as the

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

2012-10-18 Thread Vabz
Hi What exactly you are trying to do. Rgds//Vabs On Thursday, October 18, 2012 3:05:31 PM UTC+5:30, Manoj Kumar wrote: Dear Expert, please help tell me i am doing something wrong in this formula.. A B c Store ID Store ID V5/A G-199 #VALUE! V5/A G-016 V5/A G-016 #VALUE! V5/A

Re: $$Excel-Macros$$ Create HTML sample html file using EXCEL Macro

2012-10-18 Thread Vignesh S R
hi All, I have generated the html and saved in D:\user\test\tst_1.html Again i am using one macro to attach that file in mail, but cant able to attach the html file in mail.without attachment the mail program is working fine. kindly do the needful. On Wed, Oct 17, 2012 at 3:00 PM, Vignesh S R

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

2012-10-18 Thread Vabz
Hi Then you are getting correcr answer, try Multiplying 1 with Text Value eg. 1 x V5/A G-040 results in to #VALUE!. You can get values only data is non text one. Rgds//Vabs On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote: Hi, I want to know if coll A Data found in

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

2012-10-18 Thread Vabz
Hi You can do that with simple Vlookup function. Rgds On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote: Hi, I want to know if coll A Data found in Coll C, it found the value of Coll A. using sumproduct.. On Thu, Oct 18, 2012 at 3:08 PM, Vabz v...@vabs.in javascript:

Re: $$Excel-Macros$$ Re: Need formula to update status

2012-10-18 Thread Aamir Shahzad
below formula also can use with C+S+E =IF(MAX(IF($B$2:$B$17=B2,$A$2:$A$17))MAX($A$2:$A$17),Deactivate,Activate) Aamir Shahzad On Thu, Oct 18, 2012 at 12:43 PM, Manoj Kumar manoj.11...@gmail.com wrote: Thanks On Thu, Oct 18, 2012 at 1:05 PM, Vabz v...@vabs.in wrote: Hi PFA.. Cheers..

Re: $$Excel-Macros$$ Query related to Salary binding up

2012-10-18 Thread Ankit Agrawal
Hi Haseeb, Thanks for your mail. this is really help me. but I have some point which can make it more effective and efficient. - Department code will be written automatically. - and , another point is, If any employee salary is going in two percentage(%) (as in sonu),we do not need to

Re: $$Excel-Macros$$ Re: Hard to find Status for me...

2012-10-18 Thread David Grugeon
His logic is that all people who are listed against the latest date are active there and wherever else they appear. People who are not active on the latst date are inactive Regards David Grugeon On 18 October 2012 16:55, Vabz v...@vabs.in wrote: hi what is logic, i am not able to get it.

Re: $$Excel-Macros$$ Hard to find Status for me...

2012-10-18 Thread ashish koul
use this IF(COUNTIFS(A:A,A2,B:B,B2)=COUNTIFS(A:A,MAX(A:A),B:B,B2),Active,Deactive) drag it down On Thu, Oct 18, 2012 at 11:18 AM, Manoj Kumar manoj.11...@gmail.com wrote: Dear Expert. Please help me.. File attached below.. Regard Manoj -- Join official facebook page of this forum

RE: $$Excel-Macros$$ Re: Request for support for a looping macro

2012-10-18 Thread Pehrson, Dave
Don, I apologize for a delayed response, your response was shuffled my junk mail, and I had overlooked it. I appreciate you looking at my request. I'm not a programmer, so you are right on, I often do things the hard way, not knowing the easy way. Let me re-think the request and better