VBA code to rotate a list of positions/names on two columns, one row up (top row will fall last) but not to include blank cells
VBA code that can rotate in sync up one row two columns with positions/names so that the top row will always fall down on last position. The code should ignore the blank cells and only rotate the cells with data. Selection of cells is A3-B18
Cells A3 and B3 should rotate to positions A6 and B6. Cells A4 and B4 should move up one row to A3 and B3. Cells A5 and B5 should move up to A4 and B4. Basically, even though the selection is much bigger, only the cells with data should take action and rotate.