$$Excel-Macros$$ Angle calculation

hi, Can you help me to calculate angle of each pie from pie chart image using vba. Example image given below: Regards, Joseph Camill -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ circular x axis in excel graph *

Hi Rajan / vba gurus, If possible please share this file as I have a similar issue http://excelpoweruser.wordpress.com/2012/09/29/showing-values-on-angle/ On Sat, Sep 29, 2012 at 5:01 PM, Rajan_Verma wrote: > > > *Hi * > > > > *I have make it more suitable , please

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi, Thank you Ashish and Vaibhav. Ashish there was a bug in your file which Vaibhav has fixed. I will have many such sheet like final for various people to work on so there will be duplicates as well. For e.g. Person x will have RAV and TED button and Person Y will have TED and STU button, and

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi, Thank you for the efforts. Can you'll try this: I will have many such sheet like final for various people to work on so there will be duplicates as well. For e.g. Person x will have RAV and TED button and Person Y will have TED and STU button, and so on. So is there a possibility that a

Re: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Thank you Ashish and Ravi. It has still not hit the bulls eye. I am not sure if this is possible. but let me explain this again. Ravi, your concept is right, I am getting the result as per my instruction in the file. but what i am looking for is, if I click RAV, it cleards existing data from

$$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi, Please provide VBA code based on the instructions given in the excel file. Thanks, Joseph -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1)

Re: $$Excel-Macros$$ Userform - Login

Hi Pramod, None are working. On Mon, Nov 3, 2014 at 7:18 AM, Pramod Singh pramod...@gmail.com wrote: User id is 123456 Password may be 321 or 123 or the Try in three password. . Regards Pramod Pramod On 3 Nov 2014 02:02, joseph camill joseph.cam...@gmail.com wrote: Hi, I do

Re: $$Excel-Macros$$ Userform - Login

.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2

Re: $$Excel-Macros$$ Userform - Login

, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code

Re: $$Excel-Macros$$ Userform - Login

SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password

$$Excel-Macros$$ Userform - Login

Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for

Re: $$Excel-Macros$$ Line Stacked Line

Hi Chandra, If I have understood your question right, you want to know the difference between stacked line with marker and 100% stacked line with marker. 1. Stacked line and stacked line with markers Displayed with or without markers to indicate individual data values, stacked line charts are

Re: $$Excel-Macros$$ Report

Thank you Vaibhav On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi v...@vabs.in wrote: Thanks bro... On Oct 12, 2014 6:05 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, Nice Solution. Sheet is working Great. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Report

AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Yes, I tried this, and it is working great. I have made one modification. Instead of right click to the workbook, I added a Form control button and have assigned to it. Need to add more sheets and do a final check. On Fri, Oct

Re: $$Excel-Macros$$ Report

Hi Vaibhav, Thank you for the file and apologies for the late response. It is working great. Thanks and regards, Joseph Camill On Tue, Oct 7, 2014 at 10:51 AM, Vaibhav Joshi v...@vabs.in wrote: JC check this, there is sheet name C, in that mention InputSheet Names in col A OutPutsheet

Re: $$Excel-Macros$$ Report

, once all sheet is created i am selecting all sheets and sending it to PDF for publishing in to one file. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can

Re: $$Excel-Macros$$ Report

is here working through me for you.* On Mon, Oct 6, 2014 at 1:20 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the clarification. Is there any chance to get the other request, if possible. Thanks, Joseph On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi v

Re: $$Excel-Macros$$ Report

you to select sheet names adapt further changes as mentioned by you!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Oct 6, 2014 at 5:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, I think the end loop i.e. For x = 3

Re: $$Excel-Macros$$ Report

, Oct 6, 2014 at 7:46 PM, joseph camill joseph.cam...@gmail.com wrote: Thank you Vaibhav. Yes it is clear per your earlier email. On Mon, Oct 6, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote: For X=3 is not counting sheets!! It is begining selecting sheets from sheet #3 onwards..Check module

Re: $$Excel-Macros$$ Report

, or if I select STD_II it will print Final_STD_II. Thanks, Joseph Camill On Mon, Oct 6, 2014 at 8:26 PM, joseph camill joseph.cam...@gmail.com wrote: Excellent Vaibhav, Will have a micro level look at it later. Thank you. Joseph On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi v...@vabs.in

Re: $$Excel-Macros$$ Report

working through me for you.* On Tue, Oct 7, 2014 at 12:37 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, To clarify further, I will have multiple RAW sheets, the current example shows STD IV, so I will have 10 such sheets from STD I to STD 10. So instead of giving the Sheet

Re: $$Excel-Macros$$ Report

Hi Vaibhav, In addition, the format for Std IX and X will change in terms of marks display. Regards, Joseph On Oct 7, 2014 10:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Output format remains the same but there is addition / subtraction of subjects and off course

Re: $$Excel-Macros$$ Report

Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill joseph.cam

Re: $$Excel-Macros$$ Report

and then picks that sheet. NOTE: there will be slight variation in the RAW / Final sheet for various STD and that would be addition/subtraction of subjects and change in Name. On Mon, Oct 6, 2014 at 12:15 AM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Can you please explain the last loop

Re: $$Excel-Macros$$ Report

employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. Is it possible to make three

Re: $$Excel-Macros$$ Report

Hi Vaibhav, It is working perfect, as per my requirement. Will email if incase I need any further updates. Thank you very much, you made my work easy. On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers On Sep 29, 2014 9:58 PM, joseph camill joseph.cam...@gmail.com

Re: $$Excel-Macros$$ Report

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:* joseph camill joseph.cam...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Friday, September

Re: $$Excel-Macros$$ Report

in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph

Re: $$Excel-Macros$$ Report

Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the solution. I will check

Re: $$Excel-Macros$$ Report

28, 2014 at 8:58 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Vaibhav, Thank you for the file. It is very helpful. It creates various PDF as per the Name, Is it possible to have just one pdf with all the mark sheet. On Sun, Sep 28, 2014 at 7:06 PM, joseph camill joseph.cam

$$Excel-Macros$$ Report

Hi, I am working on a project where I need to print 100 report card at a time either directly to a printer or as PDF. Attached is the example workbook. All my data will be entered in sheet named Raw and my output should look like sheet named Final. Is it possible to print it to PDF / printer

RE: $$Excel-Macros$$ Re: Pie chart

Any luck with this one On Oct 6, 2013 3:16 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Ravi, Pie chart calculates the percentage by its inbuilt feature and is the whole pie is equal to 100%. I just want the first slice to be exactly in the centre to the right as I had ahown in my

RE: $$Excel-Macros$$ Re: Pie chart

** ** On Sat, Oct 5, 2013 at 4:20 PM, Ravinder ravinderexcelgr...@gmail.com wrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *joseph camill *Sent:* Saturday, October 05, 2013 12:13 AM *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Pie chart

, 2013 at 12:39 PM, joseph camill joseph.cam...@gmail.comwrote: Can anyone help me with a code On Sep 24, 2013 9:11 PM, joseph camill joseph.cam...@gmail.com wrote: Thanks for your response. I know to do it manually but my charts gets updated very often. So I am looking for an automation. On Sep

Re: $$Excel-Macros$$ Re: Pie chart

Can anyone help me with a code On Sep 24, 2013 9:11 PM, joseph camill joseph.cam...@gmail.com wrote: Thanks for your response. I know to do it manually but my charts gets updated very often. So I am looking for an automation. On Sep 24, 2013 6:54 PM, Johnnyboy5 intermediatec...@gmail.com wrote

Re: $$Excel-Macros$$ Re: Pie chart

Thanks for your response. I know to do it manually but my charts gets updated very often. So I am looking for an automation. On Sep 24, 2013 6:54 PM, Johnnyboy5 intermediatec...@gmail.com wrote: Goto the pie chart - double click on the pie - should be able to bring up a four tab choice box -

$$Excel-Macros$$ Pie chart

Hi, I have a two slice pie chart and the first slice should face to the right centre horizontally. Can you provide a macro for this. Thanks for your help in advance. Regards, Joseph -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ MOS Excel Certification

Hi, Could you please guide me with certification of MOS and its reference material to prepare for the exam. I live in Mumbai, India. Thanks in advance, Joseph Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ I need excel to find a value in the next row's cell back on the highest value of the previous cell.

Did you try offset? Sent on my BlackBerry® from Vodafone -Original Message- From: ferreg...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 6 Mar 2013 09:53:53 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ I need excel to

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

in the region. This allows you to have different people in each region if you need this later. I hope this does what you want. Regards David Grugeon On 1 February 2013 14:26, joseph camill joseph.cam...@gmail.com wrote: database.xlsxhttps://docs.google.com/file/d

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

am very busy at work but someone else may be able to help. On Sunday, 10 February 2013, joseph camill wrote: can I get the same in vba On Sun, Feb 10, 2013 at 5:18 AM, David Grugeon da...@grugeon.com.aujavascript:_e({}, 'cvml', 'da...@grugeon.com.au'); wrote: Hi Joseph Please find

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

-- *From: * joseph camill joseph.cam...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Fri, 1 Feb 2013 09:56:08 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Database sort (copy from one sheet

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

...@gmail.com Subject: Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order) Any solution friends. Sent on my BlackBerry® from Vodafone -Original Message- From: joseph camill joseph.cam...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 1

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

Any solution friends. Sent on my BlackBerry® from Vodafone -Original Message- From: joseph camill joseph.cam...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 1 Feb 2013 09:56:08 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros

$$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

database.xlsxhttps://docs.google.com/file/d/0B3PqgZIh0KQSMnhNY3RLWVRDcW8/edit Hi, Attached is the excel, for which I need some help. I want to paste data from one sheet to another sheet in a different view. I need this to be coded in vba as this is just a sample and my file is much larger

Re: $$Excel-Macros$$ Re: VBA or VSTO

Thanks Prince, could you give me some more info on VSTO. Sent on my BlackBerry® from Vodafone -Original Message- From: Prince prince141...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 3 Jan 2013 02:07:46 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Re: VBA or VSTO

Thanks Prince, will go through this and revert incase of any further queries. Sent on my BlackBerry® from Vodafone -Original Message- From: Prince prince141...@gmail.com Date: Thu, 3 Jan 2013 19:40:14 To: excel-macros@googlegroups.com Cc: joseph.cam...@gmail.com Subject: Re:

$$Excel-Macros$$ VBA or VSTO

Hi, What is the best option now, VBA or VSTO? Also can you give me its advantages/drawbacks over each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Requirement for Oracle R12 General Ledger / Cost Management Functional Consultan

No job post please. Sent on my BlackBerry® from Vodafone -Original Message- From: Manish Kaul manish@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 28 Dec 2012 22:04:40 Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Requirement for Oracle R12 General

Re: $$Excel-Macros$$ Pie Charts

The donut chart will help Sent on my BlackBerry® from Vodafone -Original Message- From: Christi Jacob christi.ja...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 14 Dec 2012 23:05:24 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re:

Re: $$Excel-Macros$$ Re: Good Laptop to Buy..

Hi, Acer is good only for basic home use, but if you need graphics as well then Acer is the wrong choice. Sent on my BlackBerry® from Vodafone -Original Message- From: Manoj Kumar manoj.11...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 23 Oct 2012 10:54:14 To:

Re: $$Excel-Macros$$ Good Laptop to Buy..

Either Dell or Lenovo Sent on my BlackBerry® from Vodafone -Original Message- From: v...@vabs.in Sender: excel-macros@googlegroups.com Date: Sat, 20 Oct 2012 12:30:29 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Good Laptop to

Re: $$Excel-Macros$$ VSTO *

Thanks Noorain Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 27 Sep 2012 12:21:17 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re:

$$Excel-Macros$$ VSTO

Hi, Does anyone have any VSTO tutorial. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- 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

$$Excel-Macros$$ Excel to powerpoint

Hi, I am using MSOffice 2010. I create charts in excel and paste them in PowerPoint as picture, the resolution of the chart is very poor. This does not happen when I use 2007 version. Please help. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- Join official facebook page of this

Re: $$Excel-Macros$$ Excel to powerpoint

Enhanced metafile Sent on my BlackBerry® from Vodafone -Original Message- From: natu.ajin...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 15 Sep 2012 12:15:19 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel to

Re: $$Excel-Macros$$ Need a Suggestion for the formula

Hi Rajan, Could you please elaborate? Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 17 Aug 2012 22:12:08 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Thanks Noorain for your effort. Also, thanks to all the people in the group for your voluntary help. Sent on my BlackBerry® from Vodafone -Original Message- From: Indrajit $nai talk2indra...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 4 Aug 2012 20:48:25 To:

Re: $$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

Hi Noorain, Please help me understand, I may be wrong. I do not see Office 2013 on Microsoft website. Is this Open Document? Thanks, Joseph On Tue, Jul 31, 2012 at 9:20 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Pascal, Yes Brother, below link is safe, I have download 2013

Re: $$Excel-Macros$$ copy color from cell base on condition formating

Please try paste special format Sent on my BlackBerry® from Vodafone -Original Message- From: pawel lupinski lupins...@yahoo.com Sender: excel-macros@googlegroups.com Date: Mon, 16 Jul 2012 07:38:57 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Sherry's HotList

Hi moderators, Per rule please ban this user. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: sherry .. sherry.w...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 16 Jul 2012 21:24:44 To: us-recruitment-and-market...@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Unique list

Thanks Noorain, Can you give me a formula to retrieve this. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 12 Jul 2012 11:47:55 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Thousand seperator in Millions

You can get this done by changing language regional settings of your PC. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: Dileep Kumar deepuk...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 12 Jul 2012 19:30:18 To: excel-macros@googlegroups.com

$$Excel-Macros$$ Unique list

Hi experts, The formulae provided by the members is working fine when I have data in one column. But if I have to do the same from multiple columns, then how do I do? Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

Hi Pankaj, Its an appreciation given to group members for helping. Correct me Ayush if I am wrong. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: pankaj gmail account pankaji...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 5 Jul 2012 09:37:17

Re: $$Excel-Macros$$ Unique value formula required

Hi Noorain, Maries and Mahesh, Please explain in detail how each of your formula works. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: Maries talk2mar...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 4 Jun 2012 03:49:32 To:

Re: $$Excel-Macros$$ HELLO

Hi, I saw a similar thing on another block, wherein the guy warned in his next mail not to open the link and said it is a spam and has not been sent by him. How can we protect our mail from such spam? Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN

Re: $$Excel-Macros$$ Introduce Yourself !!

Hi everyone, My name is Joseph. I live in Mumbai, age 34 years. I work as a Presentation Specialist. I work only on PowerPoint, Excel and Word. Thanks and regards, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: resp...@gmail.com Sender:

Re: $$Excel-Macros$$ Re: extract data from table

Noorain, I liked your formula as it is working per my requirement. Now, I need to build a chart based on this. Can we have a column chart that uses the exact columns and ignore the extras. Sent on my BlackBerry® from Vodafone -Original Message- From: joseph.cam...@gmail.com Date: Wed, 6

$$Excel-Macros$$ extract data from table

Hi, I have a table and need to extract data that is non-zero. Attached is the sample file for your reference. Thanks, Joseph -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Re: extract data from table

yes, the number of rows and columns will be the same, but the values in it may change. On Wed, Jun 6, 2012 at 1:10 AM, Vish vishwamitr...@gmail.com wrote: Hi, Is your table going to be the same? I mean the number of columns and rows going to be same?? On Wednesday, June 6, 2012 12:51:31 AM

Re: $$Excel-Macros$$ Re: extract data from table

Can you also give me an option if my number of rows change. On Wed, Jun 6, 2012 at 1:18 AM, joseph camill joseph.cam...@gmail.comwrote: yes, the number of rows and columns will be the same, but the values in it may change. On Wed, Jun 6, 2012 at 1:10 AM, Vish vishwamitr...@gmail.com wrote

Re: $$Excel-Macros$$ Creating a Chart with bubble on it

Also remember, a bubble chart has third variant, that specifies the bubble size. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: David Grugeon da...@grugeon.com.au Sender: excel-macros@googlegroups.com Date: Tue, 5 Jun 2012 10:46:32 To:

Re: $$Excel-Macros$$ MACRO

Please send it to me at josephcam...@yahoo.com Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 29 May 2012 18:26:24 To: excel-macros@googlegroups.com Reply-To:

$$Excel-Macros$$ Bold and italics

Hi, I have concatenated two values. E.g., cell A1 has 12%, and A24 has 1. I want to concatenate both values in cell A40 as 12% 1, but 12% should be bold and 1 italics. Please help. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation)

Re: $$Excel-Macros$$ Urgent Client Position ::: Senior Websphere Systems Administrator - Work Location : Eldorado Hill , CA

Hi Thomas/Sai, Please do not post job vacancy in this group. Moderator: please delete this thread. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: sai girish saisancros...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 May 2012 01:45:42

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

Good decision Ayush. Sent on my BlackBerry® from Vodafone -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 20 May 2012 07:54:03 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

$$Excel-Macros$$ 2 Values in the same cell

Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone --

Re: $$Excel-Macros$$ 2 Values in the same cell

Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are

Re: $$Excel-Macros$$ 2 Values in the same cell

On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.comwrote: Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value

Re: $$Excel-Macros$$ Re: Find column # of first value greater than specified value?

My 2 cents What I understand is row 8 has data today price minus previous day price. So in row 7 you can give: =if(d71,down,up) Sent on my BlackBerry® from Vodafone -Original Message- From: Filip Houdek ll00...@yahoo.com Sender: excel-macros@googlegroups.com Date: Mon, 30 Apr 2012

Re: $$Excel-Macros$$ Find column # of first value greater than specified value?

Can you attach an example. Sent on my BlackBerry® from Vodafone -Original Message- From: Filip Houdek ll00...@yahoo.com Sender: excel-macros@googlegroups.com Date: Sun, 29 Apr 2012 21:58:39 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Order by Rank

Thanks everyone. Sent on my BlackBerry® from Vodafone -Original Message- From: Kris krishnak...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 8 Apr 2012 06:34:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Order by

$$Excel-Macros$$ Order by Rank

Hi, I want to reorder products by rank in a particular order. It works fine when the rank is unique. But when there are two products of same rank then it does not. Please help. I reorder using index formula. Thanks in advance, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+

Re: $$Excel-Macros$$ Order by Rank

Yes it is either ascending or descending. But if there are two ranks the same for example 3 is twice then it does not work. Sent on my BlackBerry® from Vodafone -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 7 Apr 2012

Re: $$Excel-Macros$$ Unique problem

Have you applied freeze panes? Sent on my BlackBerry® from Vodafone -Original Message- From: Abhishek Jain abhishek@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 6 Mar 2012 22:03:33 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc:

Re: $$Excel-Macros$$ LOOKUP Formula for Two Table Variables

Try a combination of index and match function Sent on my BlackBerry® from Vodafone -Original Message- From: John A. Smith johnasmit...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 1 Mar 2012 12:10:21 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

$$Excel-Macros$$ Concatenate help

Hi guys, I am trying to concatenate two cells. One cell ha absolute number whereas the other cell is a percentage. For e.g., Cell A1 = 10.534809 Cell A2 = 18.5648% The output should be: Cell A3 = 10.5 18.5% But my output with Concatenate formula is 10.534809 0.185648 Please help. Best,

Re: $$Excel-Macros$$ Concatenate help

Thank your for a prompt reply. Sent on my BlackBerry® from Vodafone -Original Message- From: xlstime xlst...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 29 Feb 2012 01:04:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re:

Re: $$Excel-Macros$$ Concatenate help

Awesome, thanks Sent on my BlackBerry® from Vodafone -Original Message- From: Maries talk2mar...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 29 Feb 2012 08:38:54 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Macro to Paste excel cells to powerpoint as picture

Thanks Noorain. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 8 Dec 2011 23:01:08 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re:

$$Excel-Macros$$ Macro to Paste excel cells to powerpoint as picture

Hi Macro team, I have a lot of tables in excel that I need to paste on powerpoint. Please help me. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ sumary of worksheet's names

Check this link and let me know this was helpful. http://sourcedaddy.com/ms-excel/create-list-worksheet-names.html; Sent on my BlackBerryŽ from Vodafone -Original Message- From: Chamili Coelho da Costa chami...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 8 Nov 2011

$$Excel-Macros$$ values and percentages in stack chart

How do I add percentages and values in a normal stack chart. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

Re: $$Excel-Macros$$ Help on Indexing and Matching

I would adise you to do the following: 1. Concatenate the three cells I.e., region, province and barangay in both the Sheets. 2. Now use index and match. Let me know if this clear. Regards, Joe On Tuesday, September 6, 2011, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: Hi, I am