VBA to take a row and convert it into a list that uses two columns at a time,

[tonywatsonhelp]

Hi Everyone,
hope someone can help

I have a range K3:CD3

now The first Column is Position and the second is Name (Going from K3 across),
I want a macro that in its memory can take this info and create a list of positions and names
So if K3 = SALES
L3 = Tony
I want SALES: Tony
then a new line then M3 and N3 etc.
so I get a list,
I need this stored in VBA so I can insert it into an email
so let's say I need this sorted as "Nlist"

however, sometimes a position has a name missing, so as it creates the list I need it to say if the name is "" skip

please help if you can I've been working on this all day and only have until tomorrow to get it done
Thanks
Tony

 

[Peter_SSs]

When posting vba code in the forum, please use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details. I have added the tags for you this time.

Try

Sub Test_v3()
  Dim NList As String
  Dim i As Long
  
  For i = 3 To 13
    NList = Evaluate(Replace("LET(a,WRAPROWS(K%:CD%,2),SUBSTITUTE(TEXTJOIN({"": "",""#""},,FILTER(a,TAKE(a,,-1)<>"""","""")),""#"",CHAR(10)))", "%", i))
    MsgBox NList
  Next i
End Sub

 

[tonywatsonhelp]

It OK,
I think I have it,
Didn't notice that everything was in " " so just had it slightly wrong,
again that you peter this is going to be a huge help
Tony

 

[Peter_SSs]

Cheers.