BetAngel_Multiple Guardian excel spreadsheet

[mindiawl]

Good evening, could somebody help me please?
The standard BetAngel_Multiple excel spreadsheet comes with 10 sheets / tabs.
However when I add more tabs i name the tabs Bet Angel (11) Bet Angel (12) Bet Angel (13) and so on.
Then copy the contents of page 10 to the 3 new tabs.
So all tabs now look the same as they have the same contents in all = a blank template.
But after saving it and closing it then uploading events from guardian, only the first original 10 get synced with the data from Guardian.
Im missing something a piece of code that makes them the same as other sheets.
Can somebody help please?

Thanks
Meurig

[mindiawl]

Its ok have sorted it

[EyePeaSea]

Does the Guardian 'Excel Sheet' column for all the events, get a sheet name (first one 'Bet Angel', then 'Bet Angel (2)' etc. ?

If they don't (and assuming you've ticked the 'Auto-bind Bet Angel Sheets' option), then can you manually select the sheet name, by clicking in the 'Excel Sheet' column?

Try loading this sheet (attached to this post). It's just the normal template, but with 50 sheets. I've just tested it and it works fine.

There's a snippet of code in the 'ThisWorkbook' object. It will delete all 'Bet Angel (x)' worksheets (just leaving 'Bet Angel') and the re-create 50 new clean worksheets.

HTH

Ian

[mindiawl]

Hi, thanks ever so much the reply. I had just sorted it 30 mins before your answer. But thanks anyway.

[EyePeaSea]

I should have refreshed the browser screen (or taken less time to type the answer).


Glad it's sorted.