I didnt know there was hidden data. After some research I realized that any dates past 9/30/2011 were hidden because they have already been fixed. So, this only needs to be done for dates up to 9/30/2011 and shouldnt be done after. If the macro pulls everything I can always filter out later dates.