Transplant data from one column to another but if the transplanted data has a different measurement, include a parenthesis

[Piaba]

Good morning everyone,

I would like to have help with a macro that will transplant data from one column to another but if the transplanted data has a different measurement type, include a parenthesis in the outputted column with an increment (like in the image below).

The distance column will be the the source of the data, total distance the output. I want the macro to check if it was measured using analogical measure tape, if so, include the 0.5 mm increment in the total distance in parenthesis.

Any help will be greatly appreciated.

 

[Piaba]

Found the solution already, thanks guys.

 

[Peter_SSs]

Glad to hear you found a solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.