Hi All
New to the forum so please be patient.
I currently receive orders in excel which need to be pasted into 3 seperate workbooks (warehouse 1, warehouse 2 and POD). Is there a way of copy/pasting to one workbook and the other two being automatically populated with the same data.
Further to this, is there a way that the information pasted to the first work book can be automatically sent to the second two with rules? For example the whole order is copy/pasted to the POD workbook. One of the columns of the order indictes the warehouse the item is to be picked from - 1 or 2. Could the order for warehouse 1 atomaticcaly populate the workbook for warehouse 1 orders and likewise for warehouse 2?
I apologize for any poor terminology but I have tried to explain it as best I can!
Many thanks in advance
New to the forum so please be patient.
I currently receive orders in excel which need to be pasted into 3 seperate workbooks (warehouse 1, warehouse 2 and POD). Is there a way of copy/pasting to one workbook and the other two being automatically populated with the same data.
Further to this, is there a way that the information pasted to the first work book can be automatically sent to the second two with rules? For example the whole order is copy/pasted to the POD workbook. One of the columns of the order indictes the warehouse the item is to be picked from - 1 or 2. Could the order for warehouse 1 atomaticcaly populate the workbook for warehouse 1 orders and likewise for warehouse 2?
I apologize for any poor terminology but I have tried to explain it as best I can!
Many thanks in advance
