# balance

1. ### Conditional Formatting based on Multiple Conditions.(With vba)

Hi. All i am using excel 2016 i have a worksheet with 100 columns and 5000 rows.. in my data a column heading "Balance in repeating after 4 columns .like Column e, column J........ i want to create a rule for conditional formatting which applies only in column which having Balance, Means...
2. ### #Value Error

I create statement sheet, which have Debit (H), Credit (F) and Balance (G) Column. Both Debit (H) and Credit (F) have Formulas to to calculate them Values. In Balance I make this Formula, =IF(ISBLANK(C8),"",H7+F8-G8) I use IF(ISBLANK just to keep the cell blank if there are no Data in that raw...
3. ### Last cell on column graph

Hi there, just wondering if a column on a graph can be made to change as different cells are chosen. As an example, Column c, cell C2 is \$400. The graph shows \$400. If i take \$200 from the total, Column c, cell C3 becomes \$200. I would like the graph to now show the new balance from C3 instead...
4. ### Columns on a graph

Hi there, just wondering if a column on a graph can be made to change as different cells are chosen. As an example, Column c, cell C2 is \$400. The graph shows \$400. If i take \$200 from the total, Column c, cell C3 becomes \$200. I would like the graph to now show the new balance from C3 instead...
5. ### Calculated Field Pivot Table

Hello All, I am trying to create a calculated field in a pivot table so that i can find the variance between the current years beginning account balance and the prior years ending account balance. <tbody> A B C D E F G H I 1999 1999 2000 1999-2000 2000 2001 2000-2001 001 Beginning...
6. ### Using excel to generate reports from a Trial Balance

I am looking for some ideas. I am not happy with the reporting features associated with my accounting software. So I would like to instead download a trail balance to excel each month and generate standard reports from that trial balance. Each month, I will want to update the trial balance...
7. ### Annuity draw-down over 25 years period

Hi gurus, I will be very grateful if any one of you can assist on this. One of our team members who created the below has left the company and when we recover the file, we realised the formulas are totally gone! And none of us are able to work out the formula. Appreciate if any kind soul can...
8. ### Withdrawing balances from accounts

Hi, Below are two banks, Bank A and Bank B where i am intending to withdraw based on the annual increase in withdrawal of 3% starting at age 70. Everthing works ok for me and and I provided the formula below that i am working on. However, I could not get the formula out for withdrawal. Given...
9. ### how to use a named range in the Offset function

In the table below, I have assigned the name "Balance" to column F. I would like to replace "F6" in I6 with the named range, "Balance", but the offset function doesn't like it. <tbody> R/C C D E F G H I J 4 Difference Formulas 5 Date Price Shares Balance Literal Relative Literal...
10. ### Inconsistant flash fill Error

Hi, If anyone can help me with this dilemma. I've created a table in excel with a set of data and formulas. This table includes column titles. The table is almost similar to a bank statement where there's an Opening Balance and Closing Balance. The first cell in the Closing Balance is simply...
11. ### Interest calculated daily, paid monthly

I have a savings account where interest is calculated daily and paid on the 3rd of each month. Most months the account is not touched but sometimes I might pay an amount in or take some out. Have created a spreadsheet with columns for amounts in/out, daily balance, number of days between...
12. ### Simple Pivot Table Sort Problem

Hello, I am trying to solve a problem a colleague is having with a simple pivot table. She has two data elements "Den Rsn Code" and Description. She has two sum values: Count of Den Rsn Code and Sum of Total Balance. The table is in tabular format. We are using Excel 2016. We cannot get...
13. ### code consolidate data from multiple sheets to one sheet

hi, guys i'd like code works to consodilate data from multible sheets to one sheet i have sheets1,2,3,4,5 the data columns a,b,c,d in all sheets what i would be showing data in sheet5 but the column d contains brand is formula like this sheets5=(sheet1+sheet2+sheet4)-sheet3 and...
14. ### DB depreciation function

Hello, I have a list of assets that went in service in different dates and I want to use DB function to calculate depreciation BY MONTH. I tried =DB(\$J\$43,0,60,R2,4) where: J43 is end of PPE balance 0 salvage value useful life 60 months R2 =1 or the first period when depreciation start 4 is 4...
15. ### Calculated Column Circular Error need alternative solution

Hello, I unfortunately/fortunately learned the hard way yesterday that using the calculate function in calculated columns doesn't always work out so well and have since spent entirely too much time spinning my wheels trying to figure out an alternative solution to my report requirement. Hoping...
16. ### Using Data Validation combine with If statement with 3 accounts

I am trying to write an If statement using Data Validation drop down for a combined bank ledger. I am having trouble getting data to filter properly. I can get it to function with 2 selections but when I added the 3rd i can't figure out the statement order. Any help it appreciated...
17. ### Move value found in one column to another column based on criteria in another column

I have a large spread sheet where some values down load to the wrong column. To fix this I am looking for a macro that can look in Column H and where it finds Balance Forward look in the same row at column J and if there is a value move that to column K. Columns L and M will have values in...
18. ### How to deduct from a cell until 0 then deduct from next cell?

Hi. I'm trying to create a spreadsheet to help keep track of bills. I'd like the spreadsheet to calculate how much money I'll have left after paying bills per month. Example: <tbody> A B C D E 1 Checking account #1 balance \$10000.00 Water bill \$100.00 2 Minimum balance \$1500.00 Gas...
19. ### Searching Value in ComboBox as per comboBox Columns

Hello I would like to search values of Combobox Column values For eg typing J in comboBox column 1 it should dropdown the list with all J and respective range in column2 Now if i type A or D or : in column 2 dropdown list to display all the names and and range if typed Specificaly the Range...
20. ### Converting listed data to pivot table format - repeatedly copying and pasting between two specified instances

Hi Everyone, I am no VBA expert and appreciate any help you can provide. I would like to learn how to search for a before and after instance to copy and paste information in between those two instances. And then repeat the process. This helps to create a format usable for a pivot table. For...