monthly

Hi there New user here! I am building a financial model and want a quicker way to spread the revenue. I have a monthly P&L going for 5 years and I have to spread the monthly revenue across 12 months in a separate tab. Source file: <tbody> Jan 17 Feb 17 Mar 17 till Dec 21 Monthly...

Alright, I have a project I'm trying to drum up for monthly budget stuff. I pull down a monthly transaction history from the bank. date, desc, category, amount for the 4 fields. That goes into tab 1 per se. But my wife really prefers to see things on a calendar type layout vs just a list...

Hello, 1. Salaries are reported annually. However, they can change each month. 2. Bonuses are paid irregularly over different months. I am trying to achieve: Show in the table "Yearly Salary Vs Bonus" the correct results for Salary and Bonus while selecting a specific Month. OR if Selecting...

Given an annual interest of 10%, how do you calculate the equivalent monthly interest?

Hi Everyone. I need help with an IF formula. Normally I can do these but this one is a bit more complicated and my boss is wanting a solution ASAP. UGH! Anyways... What I need: I need the RETURN VALUE cell in Workbook 1 l to be populated with the Monthly Run - Territory in Workbook 2 amount for...

Dear All, I am working on an Excel dashboard. One of the requirements is to display monthly and quaterly data on a single graph depending on user's selection. If the user wants to see volumes per months, the graph should present monthly data. If the user chooses to see the quaterly data, the...

Hi Everyone, I have few tabs in an Excel Sheet with set of data and few graphs. Most of these data and graphs are monthly sales figures formatted on tables to show some trends and percentages. Each month I need to copy some of these tables and graphs into PowerPoint slides. I heard there...

Thanks for the patience over these questions. The answers really are helping me learn. Could someone please clarify why "Monthly is dim as string when the return is a value? Thanks. Dim Monthly as string Monthly = InputBox("Enter your monthly salary:")

Hi, I figured I would make a new thread since I wrote too much confusing stuff in the other one, so hopefully this explain it better. I want to have a formula that will automatically yield an adjusted balance on the same day each month. Here is what I tried: =D6 - FV(D4/12, DATEDIF(D3...

Hi all, I am kind of a newbie to excel and would appreciate your help. I set up a budget sheet and I am trying to figure out a formula that will automatically perform a set function on the same day each month. As example: I want a cell to show the monthly adjusted balance of an auto loan. It...

I'm trying to build a payment schedule that shows the monthly payment on each month, but I'm having trouble with the conditions for populating the amount. The table below shows what I'm trying to do - the values are shown in row two and the formulas in row three. The formula for total months...

A - Client numbers (duplicates when applicable along different lines of business) K - fixed monthly number count per line of business The CAPS sheet is our monthly recurring revenue. I'm aiming to distribute that recurring monthly revenue across the (K) column IF A=duplicate paths. Having...

Hi out there in excel land. I am looking for help with a formula (non VBA) for E2 copied down and across to distribute amount by criteria selected. Example below with results. Appreciate in advance any help. Thank you. <tbody>#DAE7F5[/URL] "] A B C D E F G H I J K L M N O P...

OK, here's what I have going. I've pulled historical rainfall data and would look to summarize all the rainfall for each month so I can see the annual rainfall. Two things I need to do: 1. In Sheet Annual Summary, H2, I want it to look in Monthly Summary, Column A. If a date in Monthly...

Hey everyone I had a quick question regarding an excel calendar...You can download my file here: https://drive.google.com/open?id=1rst5mp7<strike></strike> Download it and click on the 'monthly view' sheet...What Im trying to figure out is once you click on monthly view in the Cell "M" add...

Hi, I wonder if anyone can help. I have monthly wage spreadsheets, with a tab for each employee with start and finish times split into days and weeks and total hours worked which is then summarised into a monthly tab for processing of wages. However, I would like a daily and weekly record...

Hi all, I'm very new to VBA. I'm trying to copy a one month data (let's name this Workbook A) and paste it on a compiled workbook of monthly data (Workbook B). So I'm trying to figure out how to remove duplicate entries of monthly data in Workbook B, while at the same time making the data...

I have a workbook with 32 sheets, one sheet for each day, multiple formulas on each sheet. Then I have one sheet that is the monthly totals. I want to copy cell information from each of the 31 sheets and put them on the monthly. ex. sheets 1-31 has a cell for total hours, on the monthly I have...

Hi all, This is no doubt ridiculously easy if you know VBA, which I don't - I'm a complete beginner to VBA! I've searched the web generally, and of course this forum first, and haven't been able to find anything that completely fits my situation. I've set up a spreadsheet that allows my team...

Hi every one, I have a large database with 10 years of data I want to extract monthly data from it but the problem is that my monthly period starts at 9th of every month and ends at 8th of next month . I want to have a column that shows which month is the line in (my custom month) how can I do...