I have a spreadsheet that has 9 columns and a varying amount of rows.

I need to create a macro that selects all 9 columns for every row in which column #2 has data.

Appreciate any help.

Thanks