I've got a new job and am trying to earn brownie points. Please help.
In an excel spreadsheet being used to track spending of grant money there
are several pages to catagorize expenses (Item 1, Item 2, Item 3, etc.). The
1st page is a summary sheet (AcctLedger). We want to just put info in one
time on the catagory sheets and have it all tabulated on the summary sheet.
In my mind I see it this way: as we type in a value/description on any page,
that value will be copied to the same column in the AcctLedger at the next
empty row. Besides the code, do I need a function to run automatically in the
possible range of cells on the first page, or is there another trick?
I'm a marco/vba novice, but willing to learn. Thank you in advance for any
help, guidance, and support.