I'll be honest! I don't know much about Excel, I'm trying to learn a few things. Someone a few years back helped me with this separator code, to separate the races and leave 2 blank spaces in between. I've tried to find this code to see if I could adjust it but I don't know even where it is.
I've attaching two examples-
1. The pic and zip file shows an Excel sheet with data. Notice on the left the column RN. This is the race number which runs 1 to 10 generally. Also notice the header on top ei..TK,RN,HORSE etc...
The command button you'll also notice on the top right of the sheet. Ive loaded data in this sheet so as of right now you would press the command button. The code then would separate the RN 1,2,3 etc.. and put the top header on top of each separation and leave two blank spaces in-between.
The program is set-up with data. Just press the command button to see how it works if you want.
I need to make a change to this separation Between RN numbers-
I need the first header with RN1 to be placed at LINE 5. Then have EXACT placement with each header at 20 line intervals, so...RN2 with the header on top would be at line 25, RN3 AT line 45, RN4 AT line 65, RN5 at line 85 etc...
Thanks ahead of time with any help on this or a direction to get a handle on how to do this.
Mitch
Bookmarks