Hello - this site has always been a great source of help
once again
i am looking for VB code that will select from cell H4 out to the last column/last cell
then with that selection perform two functions
find null values and replace with NR
copy the conditional formatting of H4 and paint brush to the last cell / column
excel version 2013
cells can contain null values
employee id will always have a value
again thank you
<tbody>
</tbody>
<tbody>
</tbody>
once again
i am looking for VB code that will select from cell H4 out to the last column/last cell
then with that selection perform two functions
find null values and replace with NR
copy the conditional formatting of H4 and paint brush to the last cell / column
excel version 2013
cells can contain null values
employee id will always have a value
again thank you
<tbody>
</tbody>
train 1 | train 2 | train 3 | train 4 | train 5 | train 6 | |||||||
ABC123 | ABC124 | ABC125 | ABC126 | ABC127 | ABC128 | |||||||
Division | data | more data | Manager | Employee | Emp Id | Pct Comp | Push | Push | Question | Push | Push | Question |
hr | west | north | Fred | emp1 | 11 | 89.5% | NR | Complete | Complete | Complete | ||
hr | west | north | wilma | emp2 | 12 | 96.9% | NR | Complete | Complete | Complete | ||
hr | coast | north | barney | emp3 | 13 | 96.4% | Complete | Complete | Complete | |||
hr | west | north | Fred | emp4 | 14 | 100.0% | Complete | Complete | Complete | |||
hr | west | north | wilma | emp5 | 15 | 100.0% | Complete | Complete | ||||
hr | west | north | barney | emp6 | 16 | 100.0% | Complete | Complete | ||||
hr | west | north | Fred | emp7 | 17 | 58.8% | Complete | 07/31/17 |
<tbody>
</tbody>