Need a macro(s) so that when charges or payments are entered for one of 200 customers (each have a separate .xls file) it is automatically entered in a journal (separate .xls file). The customer files have a heading with customer information, 14 lines to enter charges or payments and other information on the bottom. The journal file is the same but with 22 lines. I would like to automatically print each when all rows are populated (14 lines on customer files and 22 lines on journal) much like a header and footer. One this is done, the file is saved as page 1 or 2 or 3, etc and the lines blanked out and renumber the next page.
If this is confusing, PM me and I will clarify.
Please state experience and hourly rate.