I have a sheet with x numbers of rows that i need to copy to another sheet.
If it was row 1 - 5 each time that woudl be fine but it dynamically changes.
how do i select only the rows that have data?

Second question. I have data in x numbers of rows and i want to add a "1" in
an empty column but only where data exists in the rows. How can this be
done?

Thanks.


dm.