![]() |
Need help with multiple workbooks
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. |
All times are GMT +1. The time now is 05:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com