VBA extract X number of rows and save as new workbook

Hi Guys.

Please find example sheet attached.

I've been trying to make a macro which will do the following:

Copy first 3 rows (headers)

Look at name in Column I.

Copy all rows which have this contact as a value ALSO copy total data beneath each group (5 rows under last entry)


Paste header to new workbook.
Paste copied rows to new workbook
Save workbook as Value in Column I

Any help would be appreciated guys, I'm having trouble making VB identify how many rows for each name there are...


Many thanks

F

This should do it, be sure to edit the fPATH string before running the macro on your data:

Please Login or Register  to view this content.