Removing empty rows with a macro

Hi,

I want to create a macro that will cut and paste a worksheet out of an existing workbook and tidy up the table by removing all rows where there is no value in one of the fields (product or part number for example).

Is this possible please.

Thanks,
Mike