Forum Discussion
Solved
Excel Template
I am using a general ledger with budget comparison template (pic attached). It comes populated up until a certain amount. When I try to add more data, by inserting another row, everything is pasted including the exact same formulas.
As I try to populate the sheet where the GL codes gets its data from, it won't show up on the added row... but if I use one of the GL codes given on the template, it will work...
Help!!
- It appears you need to:
a) insert a row on the YTD BUDGET SUMMARY tab and fill in the G/L Code, Account Title, and Budget columns
b) insert a row on the MONTHLY EXPENSES SUMMARY tab and fill in the G/L Code, Account Title
c) then you can add the itemized expenses using the G/L code
8 Replies
- It appears you need to:
a) insert a row on the YTD BUDGET SUMMARY tab and fill in the G/L Code, Account Title, and Budget columns
b) insert a row on the MONTHLY EXPENSES SUMMARY tab and fill in the G/L Code, Account Title
c) then you can add the itemized expenses using the G/L code- Any way you might know why it suddenly stopped working? Opened it to input more info, and none of the amounts are calculated... not sure why!!
- is the sheet/workbook set to calculate manually? check Formulas - Calculations and try Calculate Now (F9) and check the Options there.
GENIUS! Thank you infinitely!!!
