Search results for query: *

Hi Groves22 - that is absolutely, exactly what I needed!!! Many, many thanks to you. Hi ItIsHardToProgram - it's actually a report where group headers are merged above the detail. The data will change based on when the report is run, so the group headers can be anywhere on the sheet where...

I think I'm close with the below code. What I want to is merge both A1 and B1 cells together based on the value of C1. So if C1 = "Y" then merge A1 and B1, otherwise skip to the next row. My problem is the Range() function - I need to have the Range() parameters based on the current row in...

Thanks for your response. The above formula example will concatenate A1 and B1 on the D1 column. But what I need is to actually merge the actual values of A1 and B1 without creating another column. The only way I can think to do this is a macro that loops thru the values of column C and then...

I've scoured the internet for this, but haven't been able to find the code. I would like to simply merge column A with column B based on a value from column C. So if column C has a 'Y' in it, merge column A to B, if it doesn't, skip the merge and move to the next row. I've seen many examples...