Does anyone know a way that I can search a worksheet down column C, when it
is blank see if column A in the corresponding row has a number, if it does,
copy the entire row A through M and paste it on another sheet then do the
same thing on the next row down? This process would conitnue until the macro
found that both the cells in columns A and C were blank.