Hello,

So, this is sort of two questions. I've been looking up ways to do this on the internet, and the impression I got is that I would need to use some kind of VBA to achieve it. Unfortunately, I am not at all familiar with VBA.

What I'm trying to do is this: Combine the contents of a row of cells (issue 1). However, the number of cells that I want to combine changes depending on the value in a separate cell (issue 2).

For example, if cell Q7 holds an 18, I'd want to combine cells C4 through cells T4. However, if cell Q7 holds a 5, I'd want to combine cells C4 to G4. Is this possible? I've tried all these different ways within the sheet itself, but I can't seem to do it.

Thanks so much. Any assistance would be appreciated.