I have made a macro to copy and paste data from sheet1 to sheet2. I want
to be able to retain that data on sheet2. Sheet1 will be updated daily and
the marco ran again. Is there a way to have a macro go to the next
available row on sheet2 and paste the new information without disturbing the
previous data?

Thanks
Mike