FW: $$Excel-Macros$$

Dear NOORAIN ANSARI I am having huge data like attached file DATA sheet, from description column selected contains need to copy sheet2 with vba code which is very helpful for me, please see attached file sheet Data and sheet2 for your understand. Thanks in advance Azeem Quraishi

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Dear Noorain & Prince, Thank you very much for the formula & solutions. Best regards Sanusi On 7 November 2012 13:51, NOORAIN ANSARI wrote: > Dear Sanusi, > > Pls use below formula > > =LEFT(B3,FIND(")",B3,1)) > =RIGHT(B3,LEN(B3)-FIND(")",B3)) > > see attachment for more clarity. > Please u

Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel

Hi Great Noorain Bhai,Thanks very much.It is very helpful to me arrow also other symbol to use in excel Thanks again Regards Amar On Wed, Nov 7, 2012 at 11:06 AM, NOORAIN ANSARI wrote: > Dear Amar, > > See attached sheet,hope it will help you to resolve your array problem > > > On Wed, Nov 7, 20

Re: $$Excel-Macros$$ Organization Chart

Hi Paul, Thanks for the reply. Its not allowing to record a macro, and if in case we are recording the macro, we cannot edit any node.  Can you please recheck ?   Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From:

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Hi Sanusi, Please Paste the followint formulas. In D1 =LEFT(B3,2) In E1 =MID(B3,3,LEN(B3)-2) and drag up to thwe number of rows as data in B columns. Regards Prince On Wednesday, November 7, 2012 11:10:45 AM UTC+5:30, msn wrote: > > > Hi all, > > > I have a problem as per atta

Re: $$Excel-Macros$$ Excel dashboards

Thanks Noorain for sharing good stuffs on creating dashboards. Regards Prince On Wednesday, November 7, 2012 11:05:03 AM UTC+5:30, NOORAIN ANSARI wrote: > > You can also visit > > *chandoo*.*org*/wp/excel-*dashboards*/ > www.*excel*charts.com/blog/how-to-create-an-*excel*-*dashboard > > * > > On

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Dear Sanusi, Pls use below formula =LEFT(B3,FIND(")",B3,1)) =RIGHT(B3,LEN(B3)-FIND(")",B3)) see attachment for more clarity. Please use separate thread for your fresh query instead of another thread. -- With Regards, Noorain Ansari http:// noorainansari.com

Re: $$Excel-Macros$$ Excel dashboards

Thank Mr NOORAIN very much. Regards Son 2012/11/7 NOORAIN ANSARI > You can also visit > > *chandoo*.*org*/wp/excel-*dashboards*/ > www.*excel*charts.com/blog/how-to-create-an-*excel*-*dashboard > > * > > On Wed, Nov 7, 2012 at 9:52 AM, son nguyen wrote: > >> Dear all, >> >> I just read artic

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Hi all, I have a problem as per attached excel. Kindly guide me on how to resolve the issue by using formula/macro. Your assistance and help is very much appreciated. Thank you Best regards Sanusi -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORU

Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel

Dear Amar, See attached sheet,hope it will help you to resolve your array problem On Wed, Nov 7, 2012 at 9:50 AM, amar takale wrote: > Dear ashish, > Thanks for guide me,but I want arrow like in sheet Pls see sheet. > > > On Tue, Nov 6, 2012 at 9:15 PM, ashish koul wrote: > >> use Webdings for

Re: $$Excel-Macros$$ Excel dashboards

You can also visit *chandoo*.*org*/wp/excel-*dashboards*/ www.*excel*charts.com/blog/how-to-create-an-*excel*-*dashboard * On Wed, Nov 7, 2012 at 9:52 AM, son nguyen wrote: > Dear all, > > I just read article of report by excel dashbordas and like them but I > can't get more its information.Co

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

bworth - Watt need to learn to spell.. On Tue, Nov 6, 2012 at 8:07 PM, wrote: > Bhanu, Learn to spell. Paul, Right On! > > > Paul Schreiner wrote: > > Sorry you feel that way. > > > > But from someone who has had many, many hours of effort expended > > only to have someone else t

$$Excel-Macros$$ Excel dashboards

Dear all, I just read article of report by excel dashbordas and like them but I can't get more its information.Could anyone help me as doccument,examples Look forward to hear from all of you Best Regards Son -- Join official facebook page of this forum @ https://www.facebook.com/discusse

Re: $$Excel-Macros$$ Solver in excel

do you have a sample worksheet that shows how to use a solver for optimization problems. On Tue, Apr 10, 2012 at 7:51 AM, Rajan_Verma wrote: > As I study the solver, I feel this is elder brother of Goal Seek in Excel > ,where we can change only one value with Goal seek , Using Solver we can > pr

$$Excel-Macros$$ Re: QC results update tool

Hi Friends, Did you guys find time to look into my Question.I tried a lot but was unsucessfull today. Below code is what we used for connecting quality center with no sucess.This code might work for QUality center 10. But in HP ALM(Quality center 11) methodologoy is slightly different after

$$Excel-Macros$$ Follow forum rules and maintain discipline !!!

Group, Kindly request you all to follow rules that you see in signtures and I hope there will be no such heated arguments in future. You need not to respond to people who violate the forum rules, just forward me the email to ban the person. I will take decision to give warning or ban the person a

Re: $$Excel-Macros$$ Send email from outlook every 1hr to 24 hrs

On Tue, Nov 6, 2012 at 3:44 PM, veerendra vanam wrote: > > Dear all, > > i am sending mail particular updated file summary sheet as > body, every 1hr like 01:00hr,02:00hr,03:00hr > > plz any one send vba code for this work for outlook, > > -- > > *Thanks&Regards > >

Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel

use Webdings format 0 for netural 5 for up arrow 6 for down arrow Regards Ashish On Tue, Nov 6, 2012 at 6:08 PM, Aamir Shahzad wrote: > You can use the Insert symbol dialog box, short key of Altr+I+S > > On Tue, Nov 6, 2012 at 5:31 PM, amar takale wrote: > >> I want also Neutral arrow >> >> >>

$$Excel-Macros$$

Dear Experts Can somebody please help me out. How to generate in the VBA selected contains shift to another column, find attached sample file Azeem -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANN

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Bhanu, Learn to spell. Paul, Right On! Paul Schreiner wrote: > Sorry you feel that way. > > But from someone who has had many, many hours of effort expended > only to have someone else take the coding and present it as his > own, and not only get a PROMOTION because of the hours "he"

RE: $$Excel-Macros$$ Organization Chart

Please have a look here http://www.mrexcel.com/forum/excel-questions/554224-using-visual-basic-appli cations-smart-art.html Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 06

Re: $$Excel-Macros$$ Organization Chart

I also Googled "Excel vba Org Chart" and received 189,000 hits. Perhaps someone else has already done this?   Paul - “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

Re: $$Excel-Macros$$ Organization Chart

I took a look at your file. It seems to have something to do with the type of image that was inserted. I was able to double-click on the image, and a popup was presented allowing the image to be converted to a Shape collection. Once I converted it, I recorded a macro in which I changed the values

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

Sorry you feel that way. But from someone who has had many, many hours of effort expended only to have someone else take the coding and present it as his own, and not only get a PROMOTION because of the hours "he" saved, but had someone else terminated because they asked me for help... I tend to

$$Excel-Macros$$ New Member

Hi * Ayush ,* * * *Please add the below mail id in the group.* * * mohd.sa...@in.aegisglobal.com* * * * *Regards,* *Surendra Singh* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accu

Re: $$Excel-Macros$$ Re: Arrow Symbol Solution in Excel

I want also Neutral arrow On Tue, Nov 6, 2012 at 5:26 PM, Bali wrote: > Hi Amar, > > > Please find attached sheet. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurat

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi Send file with your code. Rgds//Vabs On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote: > > Hi Vabz, > > Nope, not giving the desired result... (attached the sample required > file for more info) > > > A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS) > B)

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi Vabz, Nope, not giving the desired result... (attached the sample required file for more info) A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS) B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL: REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

congratulation Rajan sir. On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori wrote: > Congrats Rajan > > On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote: > >> >> Dear members, >> >> Rajan Verma has been selected as 'Most Helpful Member' for the month of >> Oct'12. He has posted 66 posts in last mo

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Congrats Brother. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Tue, Nov 6, 2012 at 5:42 PM, Born to W

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Congrats!! On Tue, Nov 6, 2012 at 4:06 AM, Govind Mori wrote: > Congrats Rajan > > On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote: > >> >> Dear members, >> >> Rajan Verma has been selected as 'Most Helpful Member' for the month of >> Oct'12. He has posted 66 posts in last month and helpe

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Congrats Rajan On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote: > > Dear members, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > Oct'12. He has posted 66 posts in last month and helped forum members > through his excel expertise. > I truly appreciate his knowledg

$$Excel-Macros$$ Re: Arrow Symbol Solution in Excel

> > Hi Amar, Please find attached sheet. -- 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 Please Help, Urgent, Need Help, Formula P

$$Excel-Macros$$ Re: Arrow Symbol Solution in Excel

Hi Amar, I have attached a sheet. Please go thorugh. -- 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 Please Help, Urgent, Need Help,

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi I have just tested & it workz..Pl update me form your end!! Rgds//Vabs On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote: > > Hi > > Ignore earlier & consider this > > Sub email() > Dim myOutlook As Object > Dim myMailItem As Object > Dim FName As StringApplication.Calculate ' Make

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi Ignore earlier & consider this Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject("Outlook.Application") Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path &

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi Try this: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As StringApplication.Calculate ' Make sure NOW() has been updated Set otlApp = CreateObject("Outlook.Application") Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Dear Vabs, Thank you very much for spending your valuable time on my query... It is not giving me the required output... as it fails when : say for example : a) Refreshed @ 9.00 AM Data found as : 0 b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2 c)Refreshed @ 9.20AM Data found as : Mr.Ram -

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Hi This will help you: Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject("Outlook.Application") Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME With otlNewMail .To = "v...@vabs.in" .CC

$$Excel-Macros$$ Help Required on : Sending an Auto generated E-mail, If there is any Value in the Pivot

Dear Masters, Good evening... Could you kindly help me in sending an Auto generated e-mail Only when there is a value in the Pivot. Enclosed more info in the Excel sheet. Thanks in advance !!! JP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RUL

$$Excel-Macros$$ Send email from outlook every 1hr to 24 hrs

Dear all, i am sending mail particular updated file summary sheet as body, every 1hr like 01:00hr,02:00hr,03:00hr plz any one send vba code for this work for outlook, -- *Thanks&Regards * *Veerendra.Vanam* TOC TEAM Bhagyanagar Electrical &

Fwd: $$Excel-Macros$$ Send mail from outlook Every One Hr .

*Dear Ashish* * * *There are 3 customers : a, b & c.* * * Dist active passive total a 26 20 46 b 45 78 123 c 25 25 50 *It means all are having different e-mail id's, and the particular figures are to be sent only to specific customer only, then how we can send it in a single click.* * * *Pleas

Re: $$Excel-Macros$$ inquiry

see in selection pane On Tue, Nov 6, 2012 at 1:50 PM, DELIN FRANCIS wrote: > Dear Anil, > > if add more names then how can add more pics > please tell me the way boss > > regards > > *Delin.F* > > > -- > *From:* DELIN FRANCIS > *To:* "excel-macros@googlegroups.

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

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

Re: $$Excel-Macros$$ inquiry

I found it... "Me.Pictures.Visible = False" change false to true... u can see all picture one by one.. Regard Manoj On Tue, Nov 6, 2012 at 1:50 PM, DELIN FRANCIS wrote: > Dear Anil, > > if add more names then how can add more pics > please tell me the way boss > > regards > > *Delin.F* > >

Re: $$Excel-Macros$$ inquiry

Dear Anil, if add more names then how can add more pics please tell me the way boss regards   Delin.F   From: DELIN FRANCIS To: "excel-macros@googlegroups.com" Sent: Tuesday, 6 November 2012 12:11 PM Subject: Re: $$Excel-Macros$$ inquiry Dear Anil

Re: $$Excel-Macros$$ inquiry

Dear Anil, thank you very much Its wonder full man and were did you hide the picture Delin.F   अनिल नारायण गवली To: excel-macros@googlegroups.com; delin_1...@yahoo.co.in Sent: Tuesday, 6 November 2012 10:50 AM Subject: Re: $$Excel-Macros$$ inquiry Pl find Attached S