Strange no drop down box, when you click on the cell next to the venue on the left should be drop down there to select the correct venue.

if you can't see them i will make a bypass to some degree.

Excel 2010.
I get the drop down box to select venue but still "invalid meeting" when I try either auto or manual scans

I have made the changes needed, so lets see if we can get this to work for you.

Attached Files

Consensus Ratings.xlsm (7.29 MB, 418 views)

Thanks Shaun, I'll try it later

Still doing the same things Shaun, no dropdown box (where exactly is this supposed to be?) and saying invalid meeting after I press Automatic.

When you press "Meetings" it will download the days meetings, takes about 30 seconds, then you should see a screen with 2 rows of boxes, on the right you will see the days meetings on the left will be blank.

What you need to do using today as an example is next to Townsville on the left if you click you should have it drop down with a list of meetings.

Ignore any of the jackpots if they are there and scroll down till you get Townsville(QR) and click on it the box should be populated now, do this for each venue so they match up then you are good to go.

As mentioned on the instruction sheet if there are races you don't want to rate then remove the race numbers from the meetings1 sheet.

Ok mate, I'll try again and see how we go.

Shaun this is the screen I get after I download the meetings, no dropdown boxes unfortunately.

Attached Thumbnails

 

Ok i made a work around, just highlight the meeting over on the far right in the list, hit "Copy" then highlight in the left box next to the correct meeting and hit "Paste" do this for each meeting needed.


The issue is with older excel version using Data Validation that are on different pages.

Attached Files

Consensus Ratings 2000+.xlsm (7.29 MB, 453 views)

Thanks Shaun, that has worked.