budget

Hi, My first tab shows my annual budget plan, for about 130 budget lines (rows). One annual total per budget line. In my second tab, I enter invoice data (all payables) throughout the year, i.e. I'm constantly adding new rows and entering newly-received invoices. As I do this, one of the cells...

I have a workbook used to create budgets for clients. Sometimes they want to have a copy of the budget in excel so I need to export the budget to another workbook that only copies values in cells, row and column height and width and cell formatting but not the formulae in cells. Some text...

I currently have a table that has 2 categories, Budget and Amount. As seen below. I have Data Validation with a list of all the names for Budget. Under that I have Budget amount that will show the corresponding amount for the selected budget. QUESTION: I want to be able to select multiple...

Hi All, I trying to work out the formula that would populate a cell with a budgeted amount based on 2 criteria - please can anyone assist? I have attached workbook that has actuals and budget and it is cell AU 4 and5 I need to populate. For ease I have put the budget on same sheet. Thank you...

Hi Experts, please assist: I need to populate a grid (yellow cells B2:C3) which picks up Grand Totals for Budget and Actuals by Month by finding the correct data from a PIVOT TABLE which can be seen here: https://ibb.co/i0Ow9K Normally, there is a BUDGET column, and an ACTUAL column for each...

Hi everyone, I am very new to VBA - have a beginners course in a few weeks which I amlooking forward to! But in the interim I am working on some finance models andwould be really grateful for the VBA coding help to I can keep progessing. I am using one Workbook. I need to copy and paste values...

Hello, Looking for best formula or way to calculate staff time to allocate back to various revenue cost centres, i have a spreadsheet which has all 5 staff members and the % of time out of 100% they spend supporting each cost centre, if my staff budget cost was say 100k which would be best...

Hello. I have the following table (assume there is data), but the format is like below: <tbody> A B C D E F G 1 June July 2 Actual Budget Variance Actual Budget Variance 3 Product 1 4 Product 1 5 Product 1 6 Product 2 7 Product 3 8 Product...

Hi, this may be a very basic question but hopefully that means there's an easy answer! I have a fixed budget (let's call it £10,000) and I have a set number of items that I have to sell. Different items are valued at different levels and I need to calculate a budget per item, using a consistent...

Hello, Thanks in advance for any help. I'm trying to average out the top 3 expense lines on my spreadsheet that together fall under a specific dollar amount. So for example in column A I have the expense types (electric, water, sewer, etc, which all have the same indicator "E" in column B)...

<tbody> A B C D E F 1 Allocated Budget Spend Forecast Spend Total Spend (inc. Forecast) Max Budget (Overspend) Budget RAG 2 £100 £50 £25 £75 £110 </tbody> Can anyone help correct my formula please? I basically want to work out a single formula to use in F2 for the following rules...

I have created a budget file with multiple sheets, each sheet has rows by category and columns for each month. The expenses I wish to track can be in one of the following currencies: $, €, ₪, I would like to enter the cost is the currency I have paid at, let's say € so could always know the...

I have made a budget sheet on excel and I have a few columns per month. Category, Budget, Actual, Remaining. My question pertains to the Budget, Actual, And Remaining sections. Currently I have an Amount X in the budget column that remains constant. In the Actual column I have a formula that...

Simply said I need to create a project budget. I want mybudget to be linked to an input sheet where I update the total expected andwhat percentage is expected to be paid in what year and it’s automaticallyallocated to the budget output sheet. So this is what the input sheet should look like...

Hi guys, I hope someone could help me on changing the scale of my waterfall as the movement is relative small comparing to the budget and actual. So I have budget number of £10K and the middle movements are in between £100K and £11K, if I want to show the movement in a bigger scale, how to...

Needing help coming up with a formula to calculate salary expected to be used based on employee date hired, account, and pay level. See below. There are 3 tabs on my worksheet, Budget Forecaster, New Employee Tracker, and Pay Chart. Joe Smith was hired on 6/10/18 as a GS7(pay scale) which...

I previously posed here with similar question, but wanted to be able to give a more indepth understanding of what my goal was. I have two tables from my erp system that is connected to power bi. One is actuals and the other is the budget. What i have been trying to do is to create a side by...

I have two tables. One is actuals and one is the budget. I want to create a matrix that shows them side by side and then a variance. I am trying to joined them into one table. I have three coulms that it needs to match in both, location, account, and department. I was also thinking of using a...

:confused::confused::confused::confused: So the Macro I have done should work and I'm not sure why it doesn't. It keeps coming back with a Run Time Error 1004 Sub export_Data() ' Sheets(Array("Period Actuals vs Budget Graph", "Weekly Actuals vs Budget", _ "Yearly Actuals vs Budget"...

Hi I need some help. I have a gantt chart created in excel for a project, I also have a budget associated to each task in the gantt chart. The budget is monthly. Is it possible to link the gantt chart to the budget, and more specifically, if the timeframe for an activity changes (i.e. becomes...