Hello,
I am exporting a list of details from a software to Excel.
Please see the file attached (Sheet1:"Detail")
1. I would like to create a macro with which a form (please see sheet2: "Form" in the sample) will be created as many times as there are number of entries in sheet1: "Detail".
2. The macro should identify the end of each record to know when to insert another form in the second sheet. If the entry has only one row of populated data than only that row will copy it self from sheet 1 into the relevant form in sheet 2. If the entry has multiple rows of data (entry number 3 in the sample), than data from those multiple rows should be copied into one form.
Each export will contain different number of entries (the sample attached contains 3 entries).
At the end I would like to print each of the forms (sheet 2) individually.
The sample file can be downloaded from:
http://www36.zippyshare.com/v/38170509/file.html
Or can be taken from the attachments of this post.
Thank you so much for your kind help with the matter.
Bookmarks