Thread: [Solved] Fill Derby pool squares
View Single Post
 
Old 05-03-2018, 06:36 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

If anyone wants to use this or even make it better, here it is.

Rather than input the names I have it taking it from the list on the right. Have the name be the active cell before pressing Fill.

It also checks for overflow. Otherwise, if there are only four squares left and the next Fill is putting in more, the routine was going haywire.
Attached Files
File Type: xlsm Derby pool.xlsm (25.0 KB, 8 views)
Reply With Quote