Hello everyone!
I need a VBA code to comment cells on a certain range according to its value, and the content of the comment is given in another table. Please follow the example:
The table on the left is used to assign vehicles to a certain service. The table on the right has remarks about each vehicle. When I press the "UPDATE REMARKS" button, I want it to run a macro that does the following:
1) Clear all previous coments (if any) on range A4:A8
2) On range A4:A8 , comment the vehicle remarks, so that the final work looks like this:
(for the coding, ignore the red circle and arrow, as they are just to show what is to place where
)
Thank you all in advance, best regards and stay safe, mates!
Cheers!
I need a VBA code to comment cells on a certain range according to its value, and the content of the comment is given in another table. Please follow the example:
The table on the left is used to assign vehicles to a certain service. The table on the right has remarks about each vehicle. When I press the "UPDATE REMARKS" button, I want it to run a macro that does the following:
1) Clear all previous coments (if any) on range A4:A8
2) On range A4:A8 , comment the vehicle remarks, so that the final work looks like this:
(for the coding, ignore the red circle and arrow, as they are just to show what is to place where
)Thank you all in advance, best regards and stay safe, mates!
Cheers!
