SOLVED

Excel Template

New Contributor

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

2 Replies
best response confirmed by hernandezt (New Contributor)
Solution
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

GENIUS! Thank you infinitely!!!

@mtarler