I have one master file with five fields

Field1 Field2 Field3 Field4 Filename
-- -- -- -- --
-- -- -- -- --
-- -- -- -- --
-- -- -- -- --
-- -- -- -- --

I need to create one excel file per record.

I need to paste A2 data into new file A2 cell, B2 data into new file B2 cell
and finally want to save the new file with filaname which is in E2

I need to repeat the entire process for each record.

As the output required is in excel i cannot use mailmerge. I tried to record
a macro and then put a loop but failed.

Please help me to solve this.

Thanks a lot in advance..
Boss