I have an xls worksheet that has multiple salespeople in a column. Each
sale for a salesperson is in a row, making multiple sales for each
salesperson.

What I want to do is make a worksheet for each salesperson, which would
have the same first row (column heading) as the main worksheet, and
each sale for that salesperson.


This tip seemed to be on the right track, but I don't understand the
code well enough to make it work:

http://tinyurl.com/yuah


(I'm doing it by hand now - Help - getting carpal tunnel syndrome!)

-Mike


---
Message posted from http://www.ExcelForum.com/