![]() |
Program to accummulate data on ledger sheet
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. |
All times are GMT +1. The time now is 05:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com