$$Excel-Macros$$ Pivot table for Datewise Bank Balance

2010-06-02 Thread Ashish Khandelwal
Dear friends, I want to create a Pivot table with the attached data file. In that I want to check the Bank Balnce datewise or Bank wise. Please send me the Pivot table for the same which will solve my requirement. Pl shelp me in this regard. Thanks, Ashish. --

Fwd: $$Excel-Macros$$ CUSTOM VIEW BUTTON IS OFF FOR EXCEL 2007

2010-06-02 Thread big smile
Thanks for answering But even today i have try but the custom view button Which is under view bar - custom view how to put an snapshot, where u r not able to view customize button ? Sorry i do not understand what u want to say. Thanks On 1 June 2010 19:41, sudhir kumar

$$Excel-Macros$$ Re: Running Macros when Multiple Excels are open

2010-06-02 Thread Stuart Redmann
On 1 Jun., 01:57, donvreug donvr...@gmail.com wrote: The environment this is occuring in is a corporate one where there are a number of Excel workbooks each with VBA modules that are deisgned for different tasks.  Occassionally someone tells me a macro has failed, and when I check they

$$Excel-Macros$$ Excel Macro Help : Ambiguous name detected :

2010-06-02 Thread Sundarvelan N
Hi Friends, Please help me to solve the below issue. While i try to use the below code it says Ambiguous name detected :W028M Private Sub CommandButton1_Click() Dim fn As String fn = Trim(TextBox1.Text) If fn = W001M Then Call W001M TextBox1.Text = ElseIf fn = W002BW Then Call W002BW

RE: $$Excel-Macros$$ Automatic Detail Summary

2010-06-02 Thread Chandra Gupt Kumar
If you have not received any solution yet, I would like to see the Sample data worksheet. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of SLF Sent: Monday, May 31, 2010 10:45 AM To: MS EXCEL AND VBA MACROS Subject:

RE: $$Excel-Macros$$ PAID LIST TRACER

2010-06-02 Thread Chandra Gupt Kumar
Kindly attach the worksheet. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of siva Sent: Friday, May 28, 2010 3:38 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ PAID LIST TRACER Dear Team, Please help me . I HAVE LAST

Re: $$Excel-Macros$$ PAID LIST TRACER

2010-06-02 Thread Jai
Please send the file On Wed, Jun 2, 2010 at 5:07 PM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Kindly attach the worksheet. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of siva Sent: Friday, May 28, 2010 3:38 PM

$$Excel-Macros$$ Any Opening for the Excel VBA Developer

2010-06-02 Thread Jitendra Kumar Verma
Hi Groups, Any Opening for the Excel VBA Sr. Developer in Delhi NCR. I want to change. Thanks Jitendra Kr. Verma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

$$Excel-Macros$$ reading excel worksheet into an array?

2010-06-02 Thread molinari
Hi all, I want to create an array in VBA such that typical end-users can modify what goes into the array without knowing code (or looking at it). Hence, I want the array to read the contents of a worksheet, excluding the first column and first row (which are labels). i.e., I want to read the

$$Excel-Macros$$ userform with animation

2010-06-02 Thread Víctor González
hello friends need to do a userform with an animation I searched the Internet but I did not understand the solution works if anyone can give me an idea or help with an element that would be ideal. thanks from Chile -- Ing. Víctor González Erices --

$$Excel-Macros$$ Re: eliminating repetitive code in a macro

2010-06-02 Thread molinari
Thanks all, I did something like the looping method, and ended up getting into much more VB programming (and less macro-recording). Now my next question is, how to read data from a worksheet into an array, where I want it to dynamically scale as people add to the worksheet. I.e., there is a

Re: $$Excel-Macros$$ Macro File Access

2010-06-02 Thread Swapnil Palande
Hi Deepak, Save you excel as Microsoft Office Excel Add-In. After saving excel as add-in, you will get access to macros of this excel in all other excels. You can add your own menu in menu bar. If you search on google you will get code for it. I have a code for it, if you want I can forward it to

$$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-02 Thread Azhar Rai
Hi Gurus My work relates to prepare a large number of reports and I use mail merge for all this process. I have to save each and every report separately. The file name I need to use is also generated through mail merge at the very first line of each report in MS Word document. What I need is

Re: $$Excel-Macros$$ From Excel send Email to multiple user separately

2010-06-02 Thread vibs
Its amazing ...thanks mahesh for your guidance. I will try to use this program as per my requirement and if required, seek your further guidance. thanks alot once again this group rocks On May 28, 10:21 pm, Mahesh parab mahes...@gmail.com wrote: Hi i herewith attach sheet as per