Hello, I've seen several similar topics here, but not applicable to my situation as I understand them. We're using Excel 2007 with XP. The workbooks are used for production scheduling. WB 1 is used for bringing in orders and sorting, it has 24 worksheets. WB 2 is used to schedule the work, it has 32 worksheets. 8 worksheets from Wb 2 are cut and pasted into a copy of WB 1 daily using a macro to create WB 2. About 50 rows are added and subtracted from the worksheets of both workbooks during the day. I would like WB 2 to update the 24 sheets of WB 1 automatically eliminating the cut and paste and potential for errors and missing orders.
Thanks for any help on this!
Thanks for any help on this!