payment

Hi, I have the code below how can I modify it to get the email address and the subject with payment amount from the cell and add signature. Sub Send_Range() ' Select the range of cells on the active worksheet. ActiveSheet.Range("A1:D15").Select ' Show the envelope on the...

Hi, I have the following spreadsheet, which lists all payments made under client accounts by date. (Please excuse the horrible layout). <tbody> A B C D E 1 Row number Client Name Payment Date Payment Amount True or False 2 2 Dominic Holden 20/04/2018 £6.58 TRUE 3 3 Gary Baines...

Hi All, I have data in columns A to K and row 1 has headings. Column C is Payment Date. I have varying numbers of rows each day. My code so far sorts by column K and then it finds the first instance of text "ZAD -" in column K. It then inserts a row above the first instance of "ZAD -". It...

Hi, I am trying to model my in- and outgoing cash flow and want to have them dynamically change when I change the payment terms. Any ideas? Thanks! <colgroup><col width="184" style="width: 138pt;"><col width="128" style="width: 96pt;"><col width="87" span="9" style="width...

Hi guys I have an Excel workbook that is saved in a folder. What I would like to do is have a VBA routine that loops through all the worksheets that are called 'Payment 1' 'Payment 2' to 'Payment z', export to PDF and save the individual sheets/ PDFs in the same folder as the Excel workbooks...

On the Payments tab in column O I have dollar amounts of payments received in cash and checks. In column Q there are payment types of either "Cash" or a numeric value for the check number. I would like to have a Summary tab that pulls over the check payments based on what is designated as...

I am unable to get sum total for the following dataset: the columns are as follows: NO. PAYMENT AMOUNT INTEREST PRINCIPAL (D11:D1054) DATE WHEN PAYMENT IS DUE (I11:I1054) MY FOLLOWING FORMULA FAILS AND I AM OUT OF LUCK! =SUMIFS(D11:D1054,I11:I1054,"YEAR(2017)") I AM TRYING TO CALCULATE...

Hello All, Thanks in advance for whatever help comes my way. I have been doing a lot of research on how to return the date of a most recent payment, unfortunately, my situation seems to be a little different than what the videos out there are showing. Bottom line, I have a running daily...

How do i insert a lookup function to display the amount of a down payment for a first client based on membership type

I am trying to create a amortization schedule for an auto loan where the monthly payment changes based on the previous payment. I found a template that creates a amortization schedule but the payment is fixed throughout the schedule. My first payment when I first started paying was $360 for 60...

I need to create a loan amortization schedule using Access. My challenge comes as we are using compound interest and I need to determine the monthly payments. I am able to get the total to be repaid using the formula: =[LoanAmount]*((1+[InterestRate]/[CompoundType)^([LoanTerm]*CompoundType))...

I'm struggling with what I thought would be a simple formula. In column E of a spreadsheet, I have a the years contracts begin. In column G, I have the number of years the contract will last and column I has the annual payment amount. On a second spreadsheet, I have 5 years in columns G thru...

Hi, I have a model that takes inputs to calculate the estimated cost of a new building. A second output is the estimated monthly payment to finance that cost. This output is based on one of two financing options, which a user selects from a drop down menu. The calculations for that monthly...

Hi Guys! I looked everywhere and couldn't find the answer I was looking for. I need to create a macro which will send an e-mail from excel sheet. The subject should contain pre-determined text, the current date and values(numbers) from two cells. The body should have a header(range A2:L2) and a...

I know I've done this a hundred times, but it must be late. Need formula to produce the required monthly payment to reach $16,000. 15 yrs x 12 payments Earning 8.2% annually Thanks!! Mike

Hello- I have a customer transaction spreadsheet that I export out of QuickBooks and it looks mostly like this: <tbody> Column A -Customer Name Column B-Type Column F-Amount 01-ABC Invoice 50.00 Payment 50.00 Invoice 100.00 Invoice 50.00 Payment 50.00 </tbody> I'm...

Hi there I am using Power Query to import some standard customer payment reports (csv format) and then clean them up further. The customer payment reports would be in the following format: The first 6 rows would describe the payment file in general (eg. Payment reference #:, date of deposit...

Hi, Sorry bit of a newbie here!! I am making up a new timesheet for one of the departments in my company. Employees in this department get a guranteed payment of 6 hours per day, even if they dont work 6 hours that day so i have used the formula...

Hi!! Need some help. I have an amortization table for a loan. The rate can be variable with the option for lump sum payments. When a lump sum payment is made, I need the payments to stay the same with the end result being the loan is just paid off faster. Here is my calculation...

I'm a strict novice with Excel, but love what I can do and have so much to learn. I love this site as a learning tool. Here's my issue: I want to return a different mathematical equation based upon which selection an end user selects from a drop down validation list. In more detail, I...