In the attached file the macro produces an ordered list on Field2 sheet from the list, in no particular order and can be of any length, on the Field sheet, determined by the listings of the columns L & J on the Set Up sheet.
The problem I have is when the last part of the Field sheet is used, in this case rows 430 to 433 I cannot get a blank row on the Field2 sheet, in this case row 402, before continuing with the rest of the listing.
As can be seen there are a number of other lists on the Set Up sheet that I am using as part of an overall project, but am concentrating on this first. I then intend to incorporate answers to this problem into the rest.
If anyone would be willing to help me with this I can incorporate these sections into another file to post. The end result is that I produce a pdf file consisting of listings of two columns for Track events followed by Field events. The Track events have involved a bit more sorting. What I would like to do is get it all working and then ask for advice on how to improve on the way I have done it.
Many thanks in anticipation
Bookmarks