$$Excel-Macros$$ Rolling Payments Calculation

Hi, I am trying to calculate the number of payments that a customer shall have to make when purchasing certain realestate products. ** Assumptions: #Units being sold: Years 12 345 Product 15

$$Excel-Macros$$ Re: Rolling Payments Calculation

find the attached file for your desired solution Sandeep - Original Message - From: Shah kmsrah...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Friday, August 21, 2009 11:24 AM Subject: $$Excel-Macros$$ Rolling Payments Calculation Hi, I am trying to

Fw: $$Excel-Macros$$ need a good method to count next 5 months

- Original Message - From: Sandeep sandymau...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, August 20, 2009 5:53 PM Subject: Re: $$Excel-Macros$$ need a good method to count next 5 months Hi Osiso Below is some code which prints all the month form 1997 to 2009 in

$$Excel-Macros$$ Re: Rolling Payments Calculation

Hi, I am trying to calculate the number of payments that a customer shall have to make when purchasing certain realestate products. Reposting to preserve formats above: ** Assumptions: #Units being sold: Years 1 2 3 4 5 Product 1 581012

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

Hi Team, Not in this way. :( First i do not want to sort. Second the ranking should be based on Glass and should not consider the city or district. Example Glass- Based on bigest value it should rank (1,2,3) Bricks- Based on bigest value it should rank (1,2,3) Tiles - Based on bigest value it

$$Excel-Macros$$ Re: required support.

Another solution Date: Thu, 20 Aug 2009 17:18:15 +0530 Subject: $$Excel-Macros$$ required support. From: gi6...@gmail.com To: excel-macros@googlegroups.com Team, I required support from all of U. I required some formula which can calculate details of tracking from last appear. Pls refer

$$Excel-Macros$$ Re: Rolling Payments Calculation

Thanks Sandeep. But in my case I have a monthly scedule hence there are around 32 payments coming in for each product isnt there an easier way of doing this? On Aug 21, 1:30 pm, Sandeep sandymau...@gmail.com wrote: find the attached file for your desired solution Sandeep - Original

$$Excel-Macros$$ How to add buttons to Project Menu - For item 1 Click A, B, or C - For Item 2 Click A, B, C, D - etc

I want to make a Project Menu or Pick List in Excel. - There will be a long list of Items - Each Item will have a number of choices - The user can pick one choice per item - Each choice will add or deduct a cost from the project and impact the schedule... - We will be showing the impact on the

$$Excel-Macros$$ Migrating Add-ins to Office 2007

I have developed an Add-ins for Excel that worked fine in Office 2003 but not work in Office 2007. The specific problem being that it has functionality invoked by toolbar buttons. In office 2003 the toolbar is loaded by code in the Add-in but of course office 2007 has the ribbon instead. No

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

Hi Vinod, Your data is not clear. Are you talking about the sorting to be done on text enteries in column C, if so then is there any relation with the numbers in column D, OR are you taking Glass/Tiles/Bricks as the order of sorting like Big-Bigger-Biggest. Please explain? Thanks -- DILIP

$$Excel-Macros$$ Re: Rolling Payments Calculation

Dear Shah For a best solution you have to share a demo file with us.The file should have all of required possible data combinations and their conditions. Then i can try to give you an easy and best solution. Sandeep - Original Message - From: Shah kmsrah...@gmail.com To: MS EXCEL

$$Excel-Macros$$ Re: Data Validation to only allow 7 digit numbers in a entire column

Hi Wes, Attached herewith is the solution with explanation. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Aug 4, 2009 at 6:41 AM, Wes wesley.d.gi...@gmail.com wrote: I've been trying to

$$Excel-Macros$$ Dynamic Menu Creation - EVent bassd

Hi Team, I wrote piece of code to generate Dropdown Menu and call various Macros from it. This piece of code makes Menu permanent. My requirement is when User open specific WorkBook and in specific Workbook a Specific Sheet, then only custom Dropdown menu should appear. Any help on this will be

$$Excel-Macros$$ Open Outside Files from Excel VBA code - EASY Workaround using internet explorer!

Just something I wanted to share because I was excited about it! Using the code: ActiveWorkbook.FollowHyperlink Address:=http:// www.cnn.com One can avoid importing object libraries and using shells and such to open external programs through Excel (Or any Office program using VBA, I would

$$Excel-Macros$$ Sales tax discount calculation

I am trying to set up a formula to calculate the discount for sales tax filing. The allowable discount for timely filing and paying is 1.2 percent of the first $6,000 collected and 0.9 percent for the amount above $6,000. The discount is capped at $500 for each return. The formula for the