Format CSV file based on data and convert to .xls

I have CSV files generated with unknown number of rows, anywhere from 1 to the maximum. The columns will be constant, likely B2 - AO2. I have recorded a macro to do what I want, however, when recording, I can select the existing cells containing data. What I want to do with the raw CSV file:

1. Select all columns and resize to fit
2. Starting at B2, select all cells to Rn, Cn, where 'n' is the final row & column containing data (will only be 0 or 1)
3. Select only the cells with 1 in them, and highlight
4. Optionally prompt to save as filename.xls

I'm not a programmer, but can muddle through ok, and identify basic structure. I can share an example if needed, but it's pretty simple and straightforward data.

Thanks,
Mark