I have a workbook which contains details for a lot of customers, and I need to generate a new workbook from this master plan retrieving a subset of the data and using the customer name as a parameter.

I'm no macro person so before I head off down this route, I'd like to know first is this possible and how complex it is likely to be.

I'm also toying with the idea of formatting this data straight into an email on MS exchange, so again does anyone have any experience of this?

Thanks