my aswer is this

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

Hi Excel Gurus, Is there any option to add the columns to get particular value. Lets say for example as below: 500 500 500 500 150 150 Can we able to get only 300 as result by adding this column.

Hi Excel Gurus, How to Reconcile two values splitted in multiple rows in same column In the below example you may see, for each day, we have same amount in two columns but these amount are splitted in third column, how can we match these. Any suggestions. Example: <colgroup><col><col...

I'm trying to build a macro to pull/copy the same specific cell ranges across multiple worksheets onto a summary sheet. Apologies for my incompetence but I'm new to VBA and on a short timeline so any help is appreciated. I have one workbook with ~200 identical worksheets (all with different...