Hi

After alot of searching I thought Id have to ask the question as I cant find what I need. I am familar with Excel but not using macros too much. I am looking to achieve the following:

I receive a report with a list of 3 columns of info in sequence. When no volume is recorded in one of the lines it is missing.

A B C
101 Workcode 101 6
102 Workcode 102 26
103 Workcode 103 32
105 Workcode 105 42
106 Workcode 106 28
107 Workcode 107 5

ie...line 104 Workcode 104 is missing.

How can I set up a template (with macro I guess) so when I paste the file I receive into the master file in Excel that it automatically adds in a blank row when a line is missing.

I can get it with conditional formatting (deleing duplicates etc) but I dont want to have to format the file seperately each time.

Column A & Bs data never changes. The data in column C will change. The sequence goes from 101 Workcode 101 until 133 Workcode 133.

Its Excel 2010