Hello everyone,

I am very new to using macros in excel. I have played around a lot and I am getting close to what I need, but I am looking for some assistance! :)

Basically what I am trying to do is input a list of data on Sheet 1, have this data automatically be transferred onto Sheet 2, but skip any blank rows between data on sheet 1. Then have a save button on sheet 2 that then saves a separate workbook with just sheet 2 in it.

Thanks in advance!