I have a master list of employee data that I need to manipulate. Each employee works in a specified area and I need to generate the master list and have the data separated automatically by a blank line based on the job description in column O and count the number in that area. I have no knowledge of VBA. Is there any way I can do this in excel 2003 automatically? I do work with macros, would that work? I have attached a sample of what the raw data looks like and what I need it to look like. Any help you can give me would be greatly appreciated.
Bookmarks