Hi there,could some one please help me?i need to find all the blanks in one column and copy the adjacent cell onto a new sheet (sheet1)my table looks like this
<tbody>
</tbody>
on separate sheet (sheet2) i would like to get a list of all the unfilled tracking numbers outputted like:
<tbody>
</tbody>
thanks for any help you can provide
tracking no | filled date |
1234 | 1/1/20 |
1235 | 1/2/20 |
1236 | |
1237 | 2/2/20 |
1238 | 2/3/20 |
1239 |
<tbody>
</tbody>
on separate sheet (sheet2) i would like to get a list of all the unfilled tracking numbers outputted like:
tracking |
1236 |
1239 |
<tbody>
</tbody>
thanks for any help you can provide
Last edited: