@Boz_41: welcome to the forum.

... and this post did not have a sensible solution.
Maybe that's because the original post didn't have a sensible question?

You can spend an awful lot of time trying to second guess what an OP might be trying to ask ... with a distinct lack of information and no sample data or expected outcome. The OP might not have thought it through, maybe they were a little lazy? Whatever, s/he never came back to follow up and clarify. Had they done so, they undoubtedly would have got a sensible solution In fact, this was the OP's one and only post.

You should be congratulated and on developing what the question might have been and then presenting a solution. Question: why did you change the thread title to include "Excel 2007"? The OP's version is/was Excel 2003