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

2012-11-07 Thread VBA VABZ
hi can u send me sample data... Rgds On Tue, Nov 6, 2012 at 10:24 PM, veerendra vanam veerendra.va...@gmail.comwrote: On Tue, Nov 6, 2012 at 3:44 PM, veerendra vanam veerendra.va...@gmail.com wrote: Dear all, i am sending mail particular updated file summary sheet as body,

Re: $$Excel-Macros$$ Sum required from different sheet..

2012-11-07 Thread Manoj Kumar
Hi, Anybody please help me... Regard Manoj On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar manoj.11...@gmail.com wrote: Dear Expert, Please help me ...when I add new sheet (3) it should be change like that..SUM('1:3'!B2) Regard Manoj -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ Organization Chart

2012-11-07 Thread ANKUR AGGARWAL
Thanks for sharing the thread Rajan, but unfortunately code doesn't work in Excel 2003 and my client is using excel 2003. Do you have any alternative ?   Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Rajan_Verma

Re: $$Excel-Macros$$ Organization Chart

2012-11-07 Thread ANKUR AGGARWAL
Hi Paul, Thanks for the reply. Your method of double clicking and recording the macro works well for excel 2007, but its not working for excel 2003, reason being we not even getting the pop up for converting it into shape in 2003. What can be other alternative. Also I have googled but couldn't

$$Excel-Macros$$ Re: Sum required from different sheet..

2012-11-07 Thread Prince
Hi Manoj, I think we can not do it through formula only we can do it easly through VBA. So below is the small code that we generate the same formula as you want. But it has some limitation eg. your sheets name should be continues like [1,2,3.] except the sheet name Report. Dim

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

2012-11-07 Thread Karan Singh
Congrats dude!! Karan Singh On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan neerajchauhan...@gmail.comwrote: congratulation Rajan sir. On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori mori.gov...@gmail.com wrote: Congrats Rajan On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain

Fwd: $$Excel-Macros$$ Sum required from different sheet..

2012-11-07 Thread Pravin Gunjal
*you mean to say that the formula should be changed automatically, whenever you create a new sheet? * -- Forwarded message -- From: Manoj Kumar manoj.11...@gmail.com Date: Wed, Nov 7, 2012 at 2:05 PM Subject: Re: $$Excel-Macros$$ Sum required from different sheet.. To:

Re: $$Excel-Macros$$ Organization Chart

2012-11-07 Thread Paul Schreiner
The 2003 is probably going to be a problem since I no longer have access to Excel 2003. The problem, from what I can see, is that your sample file doesn't contain  a typical Org Chart object, but a picture of a sample Org Chart... I'm not sure why you cannot find info on the internet. I

Re: $$Excel-Macros$$ Extracting Keywords from String

2012-11-07 Thread Paul Schreiner
I've modified the subject to provide some meaningful information. How do you know what parts of the string are important? I mean, you've started with: MONEL;  1 1/2 X UNS 1/2 FBECOATED (1/2  CLAD; 1 1/2 CARBON STEEL, 1 1/2 LOW CARBON STEEL   and have decided that these terms are to be

Re: $$Excel-Macros$$ Organization Chart

2012-11-07 Thread Paul Schreiner
can you send me your file? I need to know what type of object you're using for the Org Chart.   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 people you

$$Excel-Macros$$ Re: Urgent Client Positions ::: .Net Lead / .Net Developer -- Work Location : St. John’s, Newfoundland, Canada

2012-11-07 Thread Ayush Jain
This member is banned -Ayush Jain On Wednesday, 7 November 2012 20:49:35 UTC+5:30, sandeep reddy wrote: *Hi,* *This is Sandeep Representing SancroSoft USA Inc.* We have an urgent requirement as follows: Please respond with resumes in MS-Word Format with the following details

$$Excel-Macros$$ Re: Chart stuff

2012-11-07 Thread santosh subudhi
Hello, Can the graph in the attchment be modified as per the below table. If so would request you to please help me with this Group1 10% Group2 20% Group3 30% Group4 15% Group5 25% Total 100% Regards Santosh santoshkumar.subu...@gmail.com -- Join official facebook page of this forum @

$$Excel-Macros$$ Plz update my new mail id in this group and remove my old(current)id

2012-11-07 Thread santosh subudhi
Hello Group Manager, Currently my mail id : santoshkumar.subu...@gmail.com is registered with this group. Would request you to remove my above email id and add my new mail id santoshkumar.subu...@hotmail.com Once done please let me know above the change. Regards Santosh

Re: $$Excel-Macros$$ Sum required from different sheet..

2012-11-07 Thread Manoj Kumar
Sorry for delay... yes Pravin.. On Wed, Nov 7, 2012 at 6:42 PM, Pravin Gunjal isk1...@gmail.com wrote: *you mean to say that the formula should be changed automatically, whenever you create a new sheet? * -- Forwarded message -- From: Manoj Kumar manoj.11...@gmail.com

$$Excel-Macros$$ Required tutorials to learn Basics of DashBoards.

2012-11-07 Thread chhajersandeep
Dear Excel Gurus, Recently I have came to know about excel dashboard and its potential while presenting reports. Can any one send me some tutorials for the beginners like me. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this

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

2012-11-07 Thread Jayaprakash S
Hi Vabs, Sorry Was on leave... I do not have any codes, so what ever you had given, i tried with it and it is asking me to run the macro for sending e-mails... Instead i want the codes : When Pivot gets refreshed, Macro should run automatically and send an e-mail if there is any change in the