Hi,
I need to save 1 workbook into different folders based on cell.value
The folders are already created in a directory with a customer number (5
digits).

On the workbook, the customer number is saved in E:1. If more than one
customer, the values are comma separated.

Based on these values, the macro should find the folder for each customer
and save the file on that folder adding today's date to the sheet name.
Last, delete the original file (It is saved in a temp folder)

any ideas I will greatly appreciate. Thanks
Gaba