brossetti1
New Member
- Joined
- Jul 7, 2011
- Messages
- 7
Hello Mr. Excel forum goers,
I have a report that I download on the first of every month organized by sales agent (Agent 101, Agent 102, etc.). Every month I download one excel sheet with sales associated with the specific sales agent and I manually seperate this data into seperate sheets by sales agent. I want to automate the process of seperating the sales agent data into seperate sheets but I dont know how to tell excel to look in the "sales agent" column and find each change in sales agent. Can anyone help me with this part of the automation process?
on a side note, Thank you to everyone on this forum, you guys are awesome and I find myself constantly using this board to help me with my work.
PS I am new to posting. If there is a "best practice" for what type of information a poster needs to give that is not clear in the post above, please let me know so I can get my act straight.
Brian
I have a report that I download on the first of every month organized by sales agent (Agent 101, Agent 102, etc.). Every month I download one excel sheet with sales associated with the specific sales agent and I manually seperate this data into seperate sheets by sales agent. I want to automate the process of seperating the sales agent data into seperate sheets but I dont know how to tell excel to look in the "sales agent" column and find each change in sales agent. Can anyone help me with this part of the automation process?
on a side note, Thank you to everyone on this forum, you guys are awesome and I find myself constantly using this board to help me with my work.
PS I am new to posting. If there is a "best practice" for what type of information a poster needs to give that is not clear in the post above, please let me know so I can get my act straight.
Brian
Last edited:
