I got some great help with this bit of code a while back:
The range used for the lookup (W6:X25) has now needed to change to this:Please Login or Register to view this content.
Excel 2016 (Windows) 32 bit
W X Y 5Option Subject Capacity 6A Ar 72 7B Ar 48 8C CP 24 9D CP 24 10D ClasCi 24 11A DT 48 12B DT 72 13A Dr 24 14B Dr 24 15C Fr 48 16D Fr 24 17D FrAI 24 18C Gm 24 19D La 48 20A Mu 24 21B Mu 24 22C Sp 72 23D Sp 24 24D SpAI 76
Sheet: Y9 Options
The options refer to:
A D16:D180
B E16:E180
C F16:F180
D G16:G180
How can I change the code to work on each of these ranges separately? Would the lookup table be better in a different format (this can change if necessary)?
Thanks for any help!
Bookmarks