Is there a way to filter some data using autofilter and then mail just the
filtered bits so that recipients only see 'their' bits - apart from copy and
pasting the filtered data to different workbooks?

Thanks