I have three workbooks that each have a tab for each month of the year. All
tabs are set up indentically. These workbooks log our purchases for the
month. Part of the purchases go to one workbook and are paid by our company,
and part of the purchases go to another and are paid by our client. Where
they go is determined my a ledger code entered on the master purchase log.
What I would like to do is enter the data on the master purchase log and have
it go to its proper workbook and sheet based on the ledger code that is
posted. Is there any simple way to do this without having to enter the data
in at least two places? Any help you can give would be very much appreciated.