Copy rows from multiple worksheets into multiple worksheets in another workbook based on criteria

[sweeberry]

Hi experts,

I've got a workbook with 4 tabs, call them tab Sales, Contacts, Accounts Payable, Accounts Receivable. Column A in all four tabs is the Customer ID.

I need a VBA script that will copy rows from each of these tabs to a new workbook with matching tabs based on unique Customer ID numbers, so that I wind up with a workbook for each customer that contains four tabs showing all records associated with them in these four categories.

Is this possible?

 

[eiloken]

Hi experts,

I've got a workbook with 4 tabs, call them tab Sales, Contacts, Accounts Payable, Accounts Receivable. Column A in all four tabs is the Customer ID.

I need a VBA script that will copy rows from each of these tabs to a new workbook with matching tabs based on unique Customer ID numbers, so that I wind up with a workbook for each customer that contains four tabs showing all records associated with them in these four categories.

Is this possible?

as i understood, you need to split original workbook to another workbooks base on each customer ID with only their contents, is that true?