To make a macro for Excel

every day We receive data in the form of a fairly simple Excel file has about 20 columns and 30-100 rows. Formulas do not.
You need to post each row 40 different files based on cell value in one column of the source file.
Algorithm:one