RE: $$Excel-Macros$$ Macro Help - Please!

2011-02-27 Thread Jenie
Thanks Ashish Hugs Love From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, February 24, 2011 5:48 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro Help - Please! hi + sign was earlier used in

Re: $$Excel-Macros$$ Group Survey : Your feedback is important.

2011-02-27 Thread Jorge Marques
Is it online the survey? it appears in my screen Thank you for taking the survey. when i click the link 2011/2/26 Ayush jainayus...@gmail.com Dear members, Thanks for all your contribution to group. I am very happy to see the great engagement in the group. For me its very important to

Re: $$Excel-Macros$$ Group Survey : Your feedback is important.

2011-02-27 Thread Ayush
Hi, This is online survey. It seems that you have already taken this survey earlier, and SurveyMonkey website is not allowing you to take this survey again. You may try from other PC :) Regards Ayush Jain -- --

$$Excel-Macros$$ To Reconcile Two Reports

2011-02-27 Thread kurikkal padinjarappalla
Dear All, Can somebody create a macro to compare two reports, like result gets in pivot table, only difference is it should show a remark column also. Please find the attached sample. Thanks in advance. Kurikkal. --

Re: $$Excel-Macros$$ To Reconcile Two Reports

2011-02-27 Thread ashish koul
try this On Sun, Feb 27, 2011 at 8:30 PM, kurikkal padinjarappalla padinjarappa...@gmail.com wrote: Dear All, Can somebody create a macro to compare two reports, like result gets in pivot table, only difference is it should show a remark column also. Please find the attached sample.

Re: $$Excel-Macros$$ Open an Excel File into its own seperate window in Excel.

2011-02-27 Thread Dilip Pandey
Hi Susan, Seems to be interesting issue:- Two workarounds:- 1) Try closing the other Excel by key combination Ctrl + W. Also check what happens when you are pressing Alt + F4 2) Look out for the option Windows in Taskbar, it should be there in the Option dialogue box. (I am not familiar with

Re: $$Excel-Macros$$ Problem on picking series in chart

2011-02-27 Thread Dilip Pandey
Hi Gaurav, I hv tried opening the attached file but it appears to be corrupted, please share the xls version of this file so that Group members can view the same. Best Regards, DILIPandey On 2/26/11, Gaurav Ahuja ga.iit...@gmail.com wrote: Hi All, I am trying to construct chart with series

Re: $$Excel-Macros$$ Multi User in Excel file

2011-02-27 Thread Dilip Pandey
Hi Sajid, Yes, it can be done. Share your file and provide the LAN path of the file to all the respective users. Sharing of the file (workbook) will allow all the users to enter data in the file at the same time. Other options for customization and security would be to allow users to edit

Re: $$Excel-Macros$$ regd: drop down button

2011-02-27 Thread Dilip Pandey
Hi Naresh, Please check the attached file for required solution. I have used Name definition manager, data validation with V-lookup option to achieve the desired result. Thanks Regards, DILIPandey On 2/25/11, naresh v naresh.veerabo...@gmail.com wrote: Hi Experts, I need some

Re: $$Excel-Macros$$ Need named range or named range book Pivot Table

2011-02-27 Thread Dilip Pandey
Hi, Please share the sample file with the Group along with the expected result. I could make out that you would like to use Named Ranges with Pivots Best Regards, DILIPandey On 2/25/11, ChilExcel chilexcel...@gmail.com wrote: Hi macro I need to double click PivotTable I need to get sheet

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-27 Thread Dilip Pandey
Hi Ayush, Few Taglines from my side:- Helping the world to Excel in their professional life Excelling in Excel Excel becomes Easy here..!! Best Regards, DILIPandey On 2/22/11, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am too excited to share that discussexcel.com website

Re: $$Excel-Macros$$ Macro to Average a series of numbers in excel

2011-02-27 Thread Dilip Pandey
Hi Dave, Please attach a sample file while replying to this email. Thanks, DILIPandey On 2/25/11, Diamond Dave dpehr...@walbro.com wrote: Expert Team, I’m struck. What I’m trying to do is create a macro that will average a series of numbers and replace the numbers in the predefined series

Re: $$Excel-Macros$$ Urgent required help in excel

2011-02-27 Thread Dilip Pandey
Hi Jitender, I think you are 90% done. After Pivot table is done, you should copy - paste the data on its location itself and select the MRP column, F5, Select Blanks, = sign, up arrow, Ctrl + Enter. The above steps can also be automated where after the pivot, all the steps can be achieved

Re: $$Excel-Macros$$ To Reconcile Two Reports

2011-02-27 Thread kurikkal padinjarappalla
Dear Ashish, Thanks for your prompt reply, Its working well but the problem is, the Column C data A,B,C, etc which i have given is only as an example, if we can't define it in prior, Is there any other solution? Regards, Kurikkal On Sun, Feb 27, 2011 at 7:03 PM, ashish koul

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-27 Thread Ayush Jain
Thank You Dilip...Awesome Tag Lines. I have shortlisted two taglines from all : 1) Excel Simplified 2) Helping the world to Excel in their professional life Group, Its not finalized, so you can submit more. Regards Ayush Jain On Sun, Feb 27, 2011 at 11:13 PM, Dilip Pandey dilipan...@gmail.com

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-27 Thread Ayush Jain
Thanks Akash, This is pity cool and short... I liked it. On Mon, Feb 28, 2011 at 10:42 AM, Akash $urkatha akash4...@yahoo.comwrote: Hey Ayush, What About 'SIMPLEXCEL'??? Regards, Aakash. --- On *Mon, 2/28/11, Ayush Jain jainayus...@gmail.com* wrote: From: Ayush Jain

Re: $$Excel-Macros$$ regd: drop down button

2011-02-27 Thread SAJID MANSOOR
Why are you using this lengthy formula? =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0)) instead of =INDIRECT($B$15) (Working Fine as above one) On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Naresh, Please check the attached file for required solution. I have used

RE: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-27 Thread Dave Bonallack
Hi Ayush, Perhaps you could play with the word 'Accelerate' Some suggestions would be: Excelerated Learning Excelerated Solutions Excelerating.com Exlceleration.com Excelerate.com Regards - Dave. From: jainayus...@gmail.com Date: Mon, 28 Feb 2011 11:07:31 +0530 Subject: Re: