One of the people in my Excel class asked the following question:
I've attached a sample copy of the file I'm wondering about. Is a VBA that can take the data that is entered into the General Ledger and auto-populate that to the corresponding category worksheet
It is a mult-worksheet spreadsheet that allocates a portion of income into each budget category and then expenses spent out of each category as well.
The Summary and Analysis sheets are both auto-filled with the correct information. I don't need anything for those two sheets. What I'm looking for is the amounts from the Gen Ledger to be populated into the specfic category worksheets. Now, some of the amounts from the Gen Ledger are divided out into other sub-ledgers (Housing, Auto, Entertainment & Miscellaneous). For those, I would need the amounts from the sub-ledgers to be populated into their specific worksheets.
I realize there are a lot of worksheets to use, and it's possible that using a Pivot Table might be a better way to filter out the data. Any help would be appreciated.
Thanks!
Bookmarks