Creating a new spreadsheet with selected data in another worksheet

[Paul in the UK]

Could anyone advise how I would go about creating a new spreadsheet with selected data that meets a set criteria in another worksheet.

 

[sr12345]

Are you asking for VBA code, or just to do this manually?

Manually, you could filter the data on the original sheet, select all, copy.

On the target sheet--paste special, check the "skip blanks" box, and then "values and number formats".

 

[Paul in the UK]

Thanks, would prefer to do this in VBA if possible