Excel-copy data in single sheet & populate multiple sheet by PO [Closed]

Report
Posts
1
Registration date
Tuesday April 4, 2017
Status
Member
Last seen
April 4, 2017
-
I'm in need of some guidance: Excel- I have one Master sheet with numerous Purchase Order # with multiple products associated with PO#. We want to separate the items with same PO# and populate specific data to multiple sheets on the same workbook. The sheets are a specific template and limited to 21 entries per form. Note: Some PO have more than 21 items, thus a 2nd or 3rd sheet is needed for same PO. Currently cut and paste, wish to make process more efficient and faster. See attached screen shots