Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Hai Friends, Thank you all for your efforts in giving me a solution. However, I wish to state that I want an advanced solution. What I want is - I already have the "Running Balance" column and I have to get the Grand Total i.e., the last value of the "Running Balance" under each Bank in the same

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Dear Nath, Pl find the attached herewith. Warm Regards, Gawli Anil On Wed, Aug 14, 2013 at 3:09 PM, Gopinath wrote: > Dear Shri Satendra Kumar, > Thank you for your suggestion. However, what I wanted is "Running > Balance" for each Bank - Datewise as well as "Grand Total Balance" > available

Re: $$Excel-Macros$$ Macro for COPY Paste

Dear ashsish Thanks for reply I will run the same and will let you know by end of the day Thanks once again Regards Shrinivas On Wed, Aug 14, 2013 at 5:29 PM, ashish koul wrote: > try this see if it helps > > Option Explicit > Sub merge_multiple_workbooks() > Dim fldpath > Dim fld, fil, FSO As

Re: $$Excel-Macros$$ how i can heading text in a list box

You do use the List Box 1 title (Name Range = TieuDe), A2:H2 1 List Box that contains the data (Name Range = DanhSach), A3:H16 2013/8/14 Divaker Pandey > Thanks Van for your reply, but i need to add header text by vba code, > where item will be add on user need at run time. > > > On Wed, Aug 14

Re: $$Excel-Macros$$ Re-arrange Imported List from Txt file

Oh goodness gracious, this is too much , i love this. Thanks Ashish, its superb. thanks a lot On Thu, Aug 15, 2013 at 3:17 PM, ashish koul wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Re-arrange Imported List from Txt file

try something like this Option Compare Text Sub test() Dim i As Long j = 6 For i = 1 To Range("a65356").End(xlUp).Row Cells(i, 1).Value = Application.WorksheetFunction.Trim(Cells(i, 1).Value) If Cells(i, 1).Value = "Full Name:" Or Cells(i, 1).Value = "Name:" Then

Re: $$Excel-Macros$$ check date on open file

Hi Pawal, Please check this code Private Sub Workbook_Open() Dim expired As Date expired = "08/18/2013" If Now() > expired Then Call Macro1 'here Macro1 is your another Macro Code which you would like to run-'when today's date is greater than 08/18/2013' Else MsgBox "Today date is not exceeded

$$Excel-Macros$$ need basic macro commands - Reg

Dear All Request to send basic macro commands like for loop, assigning value , detecting row and column value .. etc i know the c programming , foxpro commands. Thanks with Mothilal.J -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- Are you