I've created a spreadhseet to link odds in BF for BTTS compared to my stats formulas to show potential value , It's a set of sheets using linked cells and power query .
I'm using a version of the betangel multiple.xls whereby I have created multiple workbooks and renamed them 1, 2, 3, etc .
However , the "auto bind Bet angel sheets " does not seem to work when I load the markets in , I have to manually insert what sheet each market is linked to , especially on Saturdays and Sundays it's a pain !!
My question is ; do the work books need to have the original names (betangel (1) , betangel (2) ) etc for auto binding to work ? , when I select it nothing happens and I'm guessing it's to do with the names of the workbooks ?
Any help would be appreciated .
Names of Linked workbooks- Gaurdian -Excel
-
- Posts: 20
- Joined: Fri May 24, 2019 9:41 pm
You do not have the required permissions to view the files attached to this post.
-
- Posts: 20
- Joined: Fri May 24, 2019 9:41 pm
Thank you kindly - guess I am renaming lots of them so ....
Just automate itbigtimesmallshot wrote: ↑Fri Mar 12, 2021 11:56 amThank you kindly - guess I am renaming lots of them so ....
drop into code view (Alt-F11) and put the following into a code module
Code: Select all
Private Sub mRenameSheets()
Dim objWs As Excel.Worksheet
For Each objWs In ThisWorkbook.Worksheets
If Left(objWs.Name, 9) <> "Bet Angel" Then objWs.Name = "Bet Angel - " & objWs.Name
Next objWs
Set objWs = Nothing
End Sub
-
- Posts: 20
- Joined: Fri May 24, 2019 9:41 pm
ah excellent ! - Thanks a million !! - will try now
-
- Posts: 20
- Joined: Fri May 24, 2019 9:41 pm
Wow - that was quick !!!- brilliant and thanks again ODPaul
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
Is there a maximum number of sheets that can be copied and/or linked to guardian? Mine wont auto-bind more than 6 automatically and only 10 in total manually