My business (restaurant) has been using two excel spreadsheets to essentially pay bills and then record them in a ledger for several years. I'm trying to simplify the process. Using our "transmittal" (the spreadsheet we pay invoices on), we enter the invoice date, payee, invoice number, g/l account number, and dollar amount, then they go to the ledger and enter just the date, payee, and amount in the appropriate area depending on the g/l account so we can tally how much total is spent in each account. If possible, I'd like to populate the expense ledger automatically when an invoice is entered on the transmittal. In other words, have the ledger look for the g/l account an invoice is charged to and copy that data to the next available cell. There is one file, but a separate sheet for each week's transmittal and then one expense ledger for the entire month. We used to use Excel, but are switching everything to Google Sheets this year if possible. Thanks, Rich
80 freelancers are bidding on average $427 for this job
Dear, Thank for your detail requirement. I'm data analyst who have many years working experience using VBA on Excel. Could help you on this project. High quallity guarantee.