I have a worksheet containing 500 rows of potential data. Data validation list drop-down boxes are used to select assignments which are then referenced by Index & Match to automatically display in other parts of the worksheet as required. Up to 70% of the worksheet contains blank rows, waiting...