hi! how can i possibly automate a subsidiary ledger sheet?

July 27, 2017 at 06:55:18
Specs: Windows 8
an SL with a cummulative running balance from jan to dec. how can i insert rows when the blank rows alloted for each month is already utilized without affecting the monthly totals?
columns used will be for date, particulars,debit,credit and balance.Many thanks and more power!

See More: hi! how can i possibly automate a subsidiary ledger sheet?

Reply ↓  Report •

#1
July 27, 2017 at 07:06:05
I'm using excel 2007 and a macro or vba would certainly of help!

message edited by 88145


Reply ↓  Report •

#2
July 27, 2017 at 08:22:44
I think we need a bit more information. Since we can't see your spreadsheet from where we are sitting, we can't really answer your question with any specifics.

Normally, inserting a row (or rows) in a range adjusts the formula at the bottom of the range, but since we don't know how your spreadsheet is set up, that may not be the case in this instance or may not even be what you want it to do.

For example, if I have data in A1:A5 and A6 contains =SUM($A$1:$A$5), I can insert a Row at Row 3 and the formula will update to =SUM($A$1:$A$6).

As I said, we need more info before we can help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •

#3
August 23, 2017 at 01:42:42
considering row 1 is the beg credit bal for jan 1, 20xx, and row 2-4 are the slots for whatever SL transactions that may transpire during the month of january.yes, Row 5 will be the sum of Row 1 to 4 in columns Debit & Credit. Row 6 - 8 will be for the month of February with Row 9 as the sum of Row 5 - 8 on so on until December with the same mechanics. the problem is how can I automate the process considering that entries/amounts that will fill the slots will come from another sheet of the same workbook,and how to automatically insert rows if the rows provided is already utilized/filled?thanks 7 please bear with my english coz its not my native tongue, i'm from the Philippines...Again many Thanks

Reply ↓  Report •
Related Solutions


Ask Question