Macro to create a new workbook based on data in another

[marlowem]

Hi Guys,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a need to create a new spreadsheet at the press of a button (with Macro attached). So to explain:<o></o>
<o></o>
1. I have an active budget sheet which part of it tracks certain line items. Amongst information in the columns is a yes/no drop-down.<o></o>
2. I have a hidden sheet which is a template for a separate workbook<o></o>
<o></o>
I'd like to embed a button on the active sheet which when pressed, creates a new workbook based on the hidden sheet. The data needed in this sheet are the line items which have a 'yes' selected in the drop-down.<o></o>

Any help appreciated!

Thanks