Hi

I'm creating a VBA code that generates a report for our Customer Service Levels.

I've hit a wall -

If the value in Column R = "Fail-S" then I need to export the figure from Column Q to Cell "T20".

There will be multiple values and I would like them separated by a " | " if possible.

eg. 45 | 52 | 67 | etc etc etc

Any help would be greatly appreciated, as you can see from my terminology this is a brave new world for me.