For “Table 1”
in the attached file in need a code that would dynamically select last row and delete all the blank rows below it except the blank row right above “Table 2”
Please see the attached file to get a better idea of what I’m trying to accomplish. Please see the ‘Before’ and ‘After’ tab.
The reason why I need something dynamic to accomplish this is that the number of rows in “Table 1”
subject to change.