I get Bill of Materials for jobs and have to order the parts listed. Problem: There are various vendors, the parts are usually listed in no particular vendor order, and the data is stored in a different order on the BOM than I need for my PO's. My Proposed Solution: I want to make a macro that will look through a range of rows on the active workbook (my BOM), find all the data for each vendor, then copy & paste the gathered information in the right order into the correct PO Form (I have a form for each vendor). Note: If the BOM is longer than normal or the row count copied is greater than the available space (in the PO Form) I need the macro to add rows (with proper formatting) to the PO Form. BOM Format Info: Portrait Layout Purchase Info starts at row 4, Purchase Info ends at row 59 (normally) Column A: Blank Column B: Taxable (Y/N) Column C: Discount Applies (Y/N) Column D: Vendor Column E: Part # Column F: Part Desc. Column G: Qty Column H: Unit Price PO Form Info: Portrait layout Data Rows: 24-43 Column A: Blank Column B: Qty Column C: Part # Column D-G: (Merged) Desc. Column H: Unit Price Column I: Total Unit Price I have an idea for an alternative solution, but am open to anything that will resolve this.