Hello All!
Is it possible to create a rule or VBA that says, if the data is column A is not 0 then select that entire row, or all the data in that row? So, in the below scenario when I paste the following data in the spreadsheet, it would automatically select the row, or all the data in the rows with 123 and 789? Or is there an easier what to do that without manually selecting the rows? I'm not sure if I am asking this correctly.
<tbody>
</tbody>
Is it possible to create a rule or VBA that says, if the data is column A is not 0 then select that entire row, or all the data in that row? So, in the below scenario when I paste the following data in the spreadsheet, it would automatically select the row, or all the data in the rows with 123 and 789? Or is there an easier what to do that without manually selecting the rows? I'm not sure if I am asking this correctly.
123 | 0 | AAA |
0 | 0 | BBB |
0 | 0 | CCC |
789 | 0 | DDD |
0 | 0 | EEE |
<tbody>
</tbody>