Re: $$Excel-Macros$$ loop to extract balances

2014-02-14 Thread Hilary Lomotey
excellent chief, this is what i needed. thanks all for your assistance On 2/15/14, Naveen Kumar M N wrote: > This message is eligible for Automatic Cleanup! (naveenkumarmn...@gmail.com) > > Add cleanup rule: > https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DdxJQakA

Re: $$Excel-Macros$$ loop to extract balances

2014-02-14 Thread Naveen Kumar M N
Hi, See the attached sheet, it could help u out. On Fri, Feb 14, 2014 at 10:29 PM, Hilary Lomotey wrote: > Hello Experts, > > > > i need a little assistance to extract balances from the sheet attached. i > have extracted a unique list of names from the transactions. i want a in > column J net

Re: $$Excel-Macros$$ loop to extract balances

2014-02-14 Thread Hilary Lomotey
thanks Boss for the assistance, Sorry i may not have explained my expected results well. i want the results to be in column J . And it should work like a balance on each unique individuals account as if they were not dependent on the other as illustrated in column l to Q then the results of the b

$$Excel-Macros$$ Re: VBA Code for Locking/Unlocking excel sheet using password input form

2014-02-14 Thread Adam Disuza
> > Microsoft Excel Password Recovery Software easily recover Excel file > password with in just few minutes. This > software fastly crack Excel file password and unlock Excel spreadsheet > after then simply re-open MS Excel files without damaging Excel file > d

$$Excel-Macros$$ Re: VBA Code for Locking/Unlocking excel sheet using password input form

2014-02-14 Thread Adam Disuza
On Thursday, December 10, 2009 12:29:52 PM UTC+5:30, punit poddar wrote: > > Hi > > The above file will be used by two person - User and the Administrator, > administrator can edit anywhere, while the user can edit only in the range > specified, based on this I have done something in the file

Re: $$Excel-Macros$$ loop to extract balances

2014-02-14 Thread mrExcel4u
Hi Hilary, PFA...Hope it will help you.. warm regards, On Fri, Feb 14, 2014 at 10:29 PM, Hilary Lomotey wrote: > Hello Experts, > > > > i need a little assistance to extract balances from the sheet attached. i > have extracted a unique list of names from the transactions. i want a in > column

$$Excel-Macros$$ randomly select non-contiguous cells in a range vba excel

2014-02-14 Thread Pascal Scalpa
Hello, how to randomly select non-contiguous cells in a range vba excel I have a range A1:AC1 and i would like to randomly select 10 cells in it non contiguous and then each of these cells will be merge with the one on its right. Example il R1 was selected at the next step it will be merge with

$$Excel-Macros$$ loop to extract balances

2014-02-14 Thread Hilary Lomotey
Hello Experts, i need a little assistance to extract balances from the sheet attached. i have extracted a unique list of names from the transactions. i want a in column J net balances from transactions. for instance the first person will have a balance of 3007.23, the next two will have a zero b

$$Excel-Macros$$ HOW TO RECORD RECOVERY DAY'S

2014-02-14 Thread SUDHIR VERMA
Dear All, Please help me. Thanking You -- 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) Use concise, accurate thread titles. Poor thread titles,

$$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number

2014-02-14 Thread KATHIRVELAN N
Dear Friends, Please help me to get this done. Repeat the Number Series based on the Vlookup Number. Attached sample file for your reference. Thanks, Sundarvelan. N -- 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

$$Excel-Macros$$ UserForm control property reference

2014-02-14 Thread learner
Hi! Normally for a UserForm to assign new property to a control a variable is used by me like following sample code: Dim inttxtbxTp As Integer inttxtbxTp = Workbooks("..xlsm").Worksheets("").Range("...").Value Me.TextBox1.Top = inttxtbxTp This works fine. However, now

$$Excel-Macros$$ Fwd: [XL-VBA Clinic] PIVOT TABLE BASED ON CELL VALUE

2014-02-14 Thread Rakesh Kumar Sharma
Hi Experts, Is the query could be resolved with offset function? -- Forwarded message -- From: Virendra Singh Date: Thu, Feb 13, 2014 at 10:29 AM Subject: [XL-VBA Clinic] PIVOT TABLE BASED ON CELL VALUE To: excelvbacli...@googlegroups.com HI, PFA query... Thanks virendra

Re: $$Excel-Macros$$ hi

2014-02-14 Thread pankaj MBA
HELLO SATENDER, WELCOME TO THIS GROUP AND SHARE YOUR QUERY On Fri, Feb 14, 2014 at 9:03 AM, Satender Rawat wrote: > > -- > 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/disc