Moving groups of data to another workbook

[Steve Jones]

Hi,

Would someone please be able to help??. I have a sales spreadsheet that has been split into sales people. Is there an automated way either using a macro or formula that I could use that would copy all the data for one sales person into a new workbook within the same sheet.

The sales person is on each line of data. Just in case you need to know the sales person is in column J.

Any help would be great as it is currently taking me about 4 hours to sort and create new sheets.

Thanks

Steve

 

[ken2step]

Post some of you data please.

 

[Steve Jones]

How do I post data???

 

[Norie]

Perhaps using Colo's HTML Maker?

What you are asking is possible but more information is needed to give specific help?