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