Hi Guys..
forgive me if the question is not clear straight away.. happy to explain deeper or answer questions...

I have a report that is being sent daily which with gaps in orders etc...
we have standard form that needs to be filled with details from that report and then sent forward to another department for upload.

report has always 20-60 lines (each line is one order) and we have all the details in columns..
I would like to be able to fill the form for first line using all the details, and then save the file in designated folder.
and then move to line 2 line 3 etc... so at the end I would like to have 20-60 files saved which I could just send forward.
is this something that could be done using VBA?
got to say my VBA knowledge is basic so please be gentle