Thank you JBeaucaire
Ok had a snooze and restarted my machine as well as my brain and yes the code works fine I have changed it slightly for other sheets.
I am now thinking that this could be simplified further as I do not really need the data posted to Column A and C but just want to input Column B and output Column D but with the additional text that would have been in columns A and C thus B becomes A and D becomes B.
So using your code from above I have
I am still learning so how would I construct this part
so that it has the text
+ the RC1 + the
Is the code
basically saying make the output of next column equal due to the Offset(row,column) column being 1 to the right
starting from row 1 cell 1 which in this case would be starting from B1