Okay...trying to figure out macros. The only thing I have actually done with a macro is edit one after one has been created which seemed fairly basic. I run a report every night which extracts the information to an excel worksheet (The columns always vary in length but not by headers). I have created some templates that I copy and paste to a template I have created with different tabs. The tabs is basically a customer who has called in about a specific issue in different systems. I have to send specific people the customers information on these templates. I also have to count the various different issues that customers called about. So I want to be able to go through a specific column and first identify the system and +1 in another template I have put together next to the reason called. So every time it sees this reason under this system it will add 1 to that certain reason. Example below. Each our in their own cell. Not even sure if that makes a difference. So there area at least a dozen or so reasons which are all the same for each system.

Seattle Customer Education 0

Now of course this is just the beginning. I want to be able to start on same cell and column again and starting with a certain system it would count how many of a certain reason for the call. Open up another template with the number associated to of calls which would open up a workbook with that many tabs each signifying those customers. Each tab is the same template but just repeated for each customer called. I only need certain information to copy from the report to each tab and save this workbook with a certain name. Of course this is not it. I also need to copy the earlier data template from each system into an email sending it to certain people within our company. Whew.....not even sure who to attack this and should I be heading in the way of VB ???? Any advice or help on this would be greatly appreciated.