expense

When I "Paste as Value". I would like to have the text automatically replace itself to something new in the same cell. IE: "POS DEBIT - MCDONALDS" --> *Paste into cell* --> "MCDONALDS". I cannot seem to find a function to fit this once I paste it. Is there a VBA script to help? I will...

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)...

Macro Recorder gave me an error that I selected too many criteria in my attempt, so I am stumped yet again. I need help in writing a macro that applies filters on Row 4 on the "Master" sheet and exclude the following items below Sub Test8() Rows("4:4").Select Selection.AutoFilter...

I hope someone can assist with this, it's probably fairly basic. I'm a beginner with formulas so any help is very much appreciated. This is what I'm trying to accomplish: If the text in AN equals one of the text values in a separate column, then I want to enter the cell to equal the text in...

Hi, I have a table (not pivot) that contains many columns but for the purpose of this I will say two. Col A and B. In A I have supplier and in B I have expense. Firstly i filter by supplier to show all items purchased by the said supplier. Secondly I want to do a top 10 filter on the expense...

I am trying to find a formula that will handle calculating "Income Surplus/(Deficit)" regardless of Total Operating Expense calculating a positive or negative number. For example: Projected YE Income is 5,260,162 Projected YE Expense is 6,328,910 Hard Income Surplus/(Deficit) is -1,068,748...

I need to count the number of roles where either Capital or Expense > 0 (so if Cap+Exp > 0 then count it) I am having difficulty with the equation portion <colgroup><col><col span="2"><col span="3"></colgroup><tbody> A B C 1 Role Capital Expense 2 PM $ 4,500 $ 2,500...

I am trying to run a query using criteria from a form. The criteria has a combo Box with 3 options All, Expense, or Income. With the following 2 formulas I get the correct results if I select "Income" or "Expense", but get nothing if select all. <tbody>...

I have a workbook that has 20+ tabs of profit and loss information for different cost centers. I want to add text in a column A based on what the formula finds in column B. I think I should be using Match/Index but can't quite figure it out. So....directly below is my reference information...

Please help, this is a income / expense sheet that I want to track all activity for 2018 on a 2nd sheet labeled 2018 summery

I have multiple expense sheets (one for each community managed), I need to copy the expense details from these sheets to a master expense sheet. Each expense sheet totals monthly and YTD, and I don't need those rows copied. Thank you in advance for any help!

I need to calculate monthly interest expense that is compounding. This shows the format that I am needing. So what is the interest expense for Jan, Feb, Mar, etc. <tbody> Amount 33600 Period (Years) 1 Interest Rate .0903 Compounding Periods (Monthly) 12 Month Interest Expense...

I am attempting to create a Macro to auto-update an existing report. Using Microsoft Office Home & Business 2016 Edition - version 1711 Scenario: Have existing workbook named Expense Report, with 6 worksheets all named by different days and a total page. I also have a web based CSR program...

I have a long list of expenses, with accounts in the A column and amounts from different business entities in the columns to the right. The last column contains a formula that ranks the aggregate expense amounts. The rows are conditionally formatted so that rows with the 10 highest aggregate...

Hi All, I have recently set up an excel template for employees to enter their expenses in a charity I help out. In total there are 4 categories which need to be filled out in the following order: Expense Category Department Donor Project Sub-project Expense Account (Not sure how to add a...

Hi I have 4 cells Monthly income = 1000 Monthly Expense = 900 I selected all of them and went to Insert-->Chart-->Column I have 2 bars but they are one beside each other (no space) between them. How can I create space between them? The char would look much better if there is a space between...

Hello all, and as usual, thank you for the help in advance! I want to pay off a list of expenses over a certain number of months using the same amount of money each month. Once one expense is paid off, I want to allocate the money that was going to that expense to the next expense, and so on...

I'm trying to build a filter in Power Query to filter rows based on the values in 2 columns (Revenue Center and Expense Center). I need to filter the table as follows: Include rows where: [Revenue Center] <> Revenue Center A and [Expense Center] <> Expense Center A...

Thanks for your time and effort with this questions. I'm planning a budget for the next three years (retire) and I have an expense, I pay every 3 months. Row 5 - Has date headings for 3 years starting in column "E", and continuing for 1100 or so columns. Row 6 - Column "a" description of...

I've been tasked with creating functionality in our existing expense reports which will let us filter by months. The problem I am facing is the way the current expense report is formatted. TxID | Project Name | Vendor | Description| Apr | May | June | July | ..... On a different worksheet I...