PDA

View Full Version : Copy-Paste rows from multiple worksheets into a new workbook based on unique id



Beatrix
01-31-2016, 01:36 PM
Hi Everyone,

I need to copy the rows with the same unique client number in column A from each worksheet and paste them into separate workbooks for each client number by including the headings for each workbook. Also need to name the workbooks based on column B data. If you use a similar script could you please help me on this? I've attached the sample file.

Cheers
B.

snb
02-01-2016, 01:06 AM
Use advancedfilter.

Beatrix
02-07-2016, 03:52 PM
sorry snb just realised haven't replied your post but I've thought I did. Thanks very much I had a look at it but in that case I have to do it for each tab separately right?

Cheers
B.