Re: $$Excel-Macros$$ Pie Charts

2012-12-14 Thread David Grugeon
You can make two pie charts, make one larger or smaller and drag the smaller on top of the larger. Regards David Grugeon On 14 December 2012 16:32, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Guru's, I have a curious question i.e why cannot pie chart represent two sets of

Re: $$Excel-Macros$$ Merge entry cell

2012-12-14 Thread amar takale
Dear Experts Pls can anybody help me on this matter. As always, Thank you very much for all the help Regards Amar On Thu, Dec 13, 2012 at 1:00 PM, amar takale amartak...@gmail.com wrote: Dear all Can Anybody tell me formula to merge cell entry in one column if it is duplicate then over

Re: $$Excel-Macros$$ Merge entry cell

2012-12-14 Thread Pravin Gunjal
*Dear Amar,* * * *Pl share the test file.* * * *Regards* *Pravin Gunjal.* * * On Fri, Dec 14, 2012 at 5:50 PM, amar takale amartak...@gmail.com wrote: Dear Experts Pls can anybody help me on this matter. As always, Thank you very much for all the help Regards Amar On Thu, Dec 13, 2012

$$Excel-Macros$$ Link or Group to Join

2012-12-14 Thread Manjunath Narayanappa
Dear Expert I want my friends to join this group, but there are beginner and they have to start from the Scratch Is there as Link or Group . So I can suggest them to Join to this Group to learn Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE

$$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread SG
Hi Experts, I need your help in one of my problem.I want to consolidate the multiple excel files of a folder with same name numbered as 1,2,3 in to a one excel file.I have tried but unable to create a macro on it.There is only one criteria in this consolidation is that on column D of every

RE: $$Excel-Macros$$ Link or Group to Join

2012-12-14 Thread Rajan_Verma
Ozgrid.com Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 14 December 2012 7:03 To: 'excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ Link or Group to Join

RE: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Rajan_Verma
See if it helps 1) http://excelpoweruser.wordpress.com/2012/06/07/compile-worksheets/ 2) http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/ 3) http://excelpoweruser.wordpress.com/2011/07/06/compiling-workbooks/ Regards Rajan verma +91 7838100659

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread SG
hi Rajan, Thanks for the reply.I have taken the macro from 2nd link. However on running the macro, the code in 4th line 'Dim Fso As New Scripting.FileSystemObject' gives an complie error 'user-defined type not defined'. please help on this. On Friday, December 14, 2012 7:28:17 PM UTC+5:30,

RE: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Rajan_Verma
Ah.. You can add reference Microsoft scripting runtime Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SG Sent: 14 December 2012 7:54 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ Link or Group to Join

2012-12-14 Thread Manjunath Narayanappa
Dear Rajan, is this a link From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: 14 December 2012 13:55 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Link or Group to Join Ozgrid.com Regards Rajan verma +91

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread SG
may be i'm silly with the question, but really not getting it that you have replied. On Friday, December 14, 2012 8:16:28 PM UTC+5:30, Rajan_Verma wrote: *Ah..* * * *You can add reference “Microsoft scripting runtime”* * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * *

RE: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

2012-12-14 Thread Rajan_Verma
Vinay's worksheet is password protected, I think formula should be visible to all Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 14 December 2012 8:20 To:

RE: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Rajan_Verma
Ok, Open Visula Basic Editor Goto the Tool- Reference -Select Microsoft scripting runtime Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SG Sent: 14 December 2012 8:26 To:

RE: $$Excel-Macros$$ Link or Group to Join

2012-12-14 Thread Rajan_Verma
Yes www.ozgrid.com Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 14 December 2012 8:25 To: 'excel-macros@googlegroups.com' Cc: 'Rajan_Verma' Subject: RE:

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Paul Schreiner
There are LOTS of different objects that are required by different applications. Rather than try to include them all at the same time, we can include them individually as References. In order to use: Dim Fso As New Scripting.FileSystemObject The Microsoft Scripting Runtime reference is required.

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread SG
thanks but the macro is not entering in to the loop. I have edited the macro lil bit at my end.I have removed the part which is for saving the complied file i think it's not going to effect anyway. please suggest.. On Friday, December 14, 2012 8:31:22 PM UTC+5:30, Rajan_Verma wrote: *Ok,*

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Paul Schreiner
I don't think we can work that way... You're using someone ELSE's macro with YOUR files and folders and you've admitted that you've edited the macro a little bit... and you want us to suggest how to fix it without seeing  the macro, your files and folders, and what edit's you've done? Well.. I

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-14 Thread Paul Schreiner
Timothy, What you're asking is pretty tricky... --- TECHNICALLY, you cannot START an action on a Saturday and END it on a Sunday of the SAME WEEK, unless you assume that the week begins on Monday (instead of Sunday) And... for your row 11, the start time is AFTER the end time.

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

2012-12-14 Thread Timothy Kluck
Paul, Thanks for getting back so quickly. For Row 11, that was my error, it was suppose to end the following day at 11:00 AM (giving us a total of 5 Business Hours). I have attached the revised spreadsheet. Perhaps a little more explanation on my part can help. I am trying to measure a Help

Re: $$Excel-Macros$$ Pie Charts

2012-12-14 Thread Christi Jacob
i think the radar used innovatively does give option to use the pie chart with 2 variable. :) regards christi jacob On Fri, Dec 14, 2012 at 7:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Hi,* * * *You can use this Add-ins ( Unfortunately I did not get time to document it. ) * * *

Re: $$Excel-Macros$$ Pie Charts

2012-12-14 Thread joseph . camill
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$$ Pie Charts

2012-12-14 Thread ashish koul
Hi try this one too see if it helps https://sites.google.com/site/e90e50fx/home/infographic-chart-with-excel http://www.excelhero.com/blog/2012/05/excel-formulas-can-make-a-graph.html On Fri, Dec 14, 2012 at 11:05 PM, Christi Jacob christi.ja...@gmail.comwrote: i think the radar used

RE: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

2012-12-14 Thread Ayush Jain
Congratulations to all winners Thanks for the participation. -Ayush On Dec 14, 2012 8:26 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Vinay’s worksheet is password protected, I think formula should be visible to all * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]*

$$Excel-Macros$$ Capture both the action check and uncheck

2012-12-14 Thread chhajersandeep
Dear Excel guru, I want to capture check box uncheck procedure! I have assigned a macro to check box! So when I click it, it works perfectly but now I want that when I untick it, it works differently from that! Please help! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join

Re: Fwd: $$Excel-Macros$$ Capture both the action check and uncheck

2012-12-14 Thread chhajersandeep
Dear Praveen, Thanks for the reply. Actually frankly speaking I don't have any file right now with me. But I can discuss the problem. I want to hide two rows with a click in check box. So by recording macro I am able to do that!! But now I want to unhide this two row when it uncheck the Check

Re: $$Excel-Macros$$ formula without macro

2012-12-14 Thread rajeyssh
Dear Sir Data is not change because the data value is same in both the sheet for Zincmini. If we change the value in 61212 sheet the data will be change. Rgds Rajesh On Friday, December 14, 2012 2:18:03 PM UTC+5:30, amar takale wrote: Dear Swapnil, Formula is good,but if I change sheet name