by Captain Sensible » Fri Jul 16, 2021 8:06 pm
If you look at the formulas in columns Z onwards the Vlookup formula is only checking the selection sheet down to row 50, the bit in the formula showing as Selections!$A$2:$E$50
=VLOOKUP($A5,Selections!$A$2:$E$50,1,FALSE)
You just need to amend that Selections!$A$2:$E$50 to however far you want it to go, so say down to row 100 you'd amend it to Selections!$A$2:$E$100
To do that , open the sheet and press Control and H together, that will open up the Find and Replace box, ine find what stick Selections!$A$2:$E$50 in the replace with box put Selections!$A$2:$E$250 then press the "Replace all" button