Excel 2007 : Separating data to other worksheets

**jsbrewer** · 12-09-2009, 01:38 AM

I need help separating data to other worksheets. I have 7 sales agents that lists their clients, amounts paid, dates, and companies used. I have one worksheet built and that I continually update everyday. How can I take the data of each agent and copy it to their own worksheet as I type their name? I have attached a sample excel file of what I have built. I just need to tranfer the information to their own worksheet. Can anyone help?

**JBeaucaire** · 12-09-2009, 02:58 PM

This can be done with:

1) Some heavy lifting array worksheet formulas, fine in small doses, but if this sheet is going to grow and grow and grow over time, maybe not a good idea.

2) Some normal formulas with the addition of some "helper columns" to create an index for each employee. This can keep it robust, but you will have to keep those helper columns included as your sheet expands downward.

3) A macro that fills in your employee sheets "on demand".

I would choose #3, then #2, then #1. Which would you prefer?

**JBeaucaire** · 12-09-2009, 03:05 PM

This is the stock macro I have for parsing data based on a single column. I've adjusted it for your needs and installed it into your sample sheet for demonstration.

Please Login or Register  to view this content.

**jsbrewer** · 12-10-2009, 01:25 AM

Thank you sooo much...I don't know much about vba or macros. This was just what I was looking for. My wife needed help and I didn't realize how extensive this project was going to be. I figured I could piece it together, but realized I was waaay over my head. I will refer my wife to you guys.