Hi all,   I've had a look about but can't find the answer I need so hoping somone can point me in the right direction.   We have an Excel template that formats some output data (its pretty basic but the end users are used to the format and dont want to change).   I've discovered that the existing process involves someone creating a master data set in Base SAS, exporting results to a csv then spending hours copy/pasting rows into a sheet in the Excel template in order to create one final formatted output per target group/user   Is there a way to: Get Enterprise Guide to loop through a list of targets (users - several hundred) Filter the main data set to just appropriate results (approx 100 rows per user) Copy the results to a specific worksheet in the excel template (Ideally then hide the raw data worksheet in the excel workbook - I could live without this step) Save the template with the user ID of the relevant user as part of the filename. Repeat for rest of the target list  I want to end up with multiple Excel workbooks in a folder, each containing just the data for the relevant user.   Extra bonus points if you can tell me how EG could then email the work books to the right people (I have the email addresses in a seperate list)   I could do this using some VBA within Excel but it would be much better to wrap the whole process into a single EG project that can be run in one step.   Any help appreciated! ... View more