Doable with a for each loop for each supplier in a list.
http://www.rondebruin.nl/

--
Don Guillett
SalesAid Software

"AndyL82" wrote in message
...
I have a spreadsheet listing sales figures for 50-odd different suppliers.
I
need to copy sales figures for each supplier into separate spreadsheets
which
are then emailed to them on a weekly basis; the spreadsheets must be named
after the supplier. Is there an easy way to do this (using a macro etc)?
Copying, pasting and saving the data is a rather time-consuming task at
the
moment.
Thanks
Andy