formula to generate reordring or resorting from given word

[newbexcell]

hello
need formula to generate reordring or resorting from given word
example i have this 3 word or lets say more
a1=cat b1=dog c1=bee
now i need formula to reorder them on max possible combination to be generated in bellow rows
and formula work with more words and mean generate max combination
cat bee dog

dog cat bee

dog bee cat

bee dog cat

bee cat dog

thanks

 

[newbexcell]

Re: formula to generate reordring or resorting from givin word

this is macro i use maybe problem with it?

Sub Macro4()
            '
            ' Macro4 Macro
                ' Macro recorded 18/03/2019 by bob
        '
                                
    '
    For j = 1 To 4
    For k = 1 To 4
    For l = 1 To 4
    For m = 1 To 4
    Cells(1, 6) = j: Cells(2, 6) = k: Cells(3, 6) = l: Cells(4, 6) = m
    thisperm = Cells(7, 7)
    Sum = Sum + 1
    Cells(Sum, 1) = thisperm
        Next m
            Next l
        Next k
        Next j
                End Sub

 

[oldbrewer]

Re: formula to generate reordring or resorting from givin word

make mytable equal to I1:J4 for test purposes, and not sure why you define the sheet - I use excel 2000 so maybe your version is different........

 

[newbexcell]

Re: formula to generate reordring or resorting from givin word

in name box i put I1:J4 then enter mytable that how created

ok is this correct? if its correct way its still generate number
http://ipic.su/img/img7/fs/14.1553176066.png