Hello everyone,
I've been increasingly working with Excel for my job. With some tasks becoming repetitive, I thought that I should start learning Macros to make what I have to do as quick and efficient as possible.

I don't have experience working with Macros, although I've been studying VB.Net for several months now, so that should speed along my learning process at least a little bit.

One of the first Macros I hope to write is something that I believe would help big time with some of the sales report that I have to do.

One simple report for example is I take the weekly sales figures for each of our sales people and put them into a spreadsheet every month, while comparing it to the previous year... It's not a difficult report to put together, but there's one issue that makes it a pain in the rear end. In the software that we use to store our sales reports, if a sales person has $0 in sales for the date range that I've specified, they will not show up at all. This makes me unable to just copy and paste columns because a sales person may be in the data one week and not in the data the next. I want to make a Macro that will compare a column listing sales people to a list of all of our sales people and create rows for sales person that is not already included in the column.

Since I'm new to this, I was hoping somebody could give me either some sample code or a suggestion on how to best go about accomplishing this. Thank you in advance for any helpful feedback.