string manipulation, move letter back in the string

I am having a bit of trouble coming up with a working vba code to move letters back in a string with some constraints and I would appreciate some help

String KEY has fixes size of letters ie "ABCDEFGHIJ"
There is another string LOCK that contains letters that are imovable in the string KEY. ie "AC"
Finally I have the Letter string that contains the letter that is moving ie "J"

What I am doing is that I am moving the Letter up the key string and once it reaches the end of it it goes back to the begining of the KEY string ie to position 1.

It could be done with a simple code Result=right(KEY,len(key)-1) & LETTER

The problem is that the LOCK string contains letters that are immovable in the KEY string, which means that the letters A will always occupy the 1st spot in the Key string and C the third.

so for ie when trying to move J to the beginning of the string the result instead of being "JABCDEFGHI" should be "AJCDEFGHI"

if the LOCK string was "AB" then the result would be "ABJCDEFGHI"

if LOCK was "BC" then the solution is JBCADEFGH"

Any help would be appreciated with some code to achieve this.

Its brilliant.
Thank you Shg.

Excellent code because I will learn from it.

Shg,

Is it possible to modify the code so that it will work regardless of where Smov is in the sInp string?

It seems that it only works if Smov is in a higher position than the Sfix letters.

To make it work regardeless of where the Letter J is?

If the letter J is not already at the last place in the string then if I try to move it by one it will move N spots according to the sFix string.

Suppose Sinp is AJCDEFGHIB

with Sfix as AC then moving J one up would make HJ report ADCJEFGHI (Because C is locked in the string)

Shg,

I have been playing with your code and it seems to work but at some point it breaks.
For ie
Sinp="CEFAHGIDB"
sFix="AEDCIF"
sMov="B"

Running thru the code hj gets as result "CBFEHGAID"

This is wrong. The correct result should be "CEFABHIDG"

Do you know why the code breaks this way and can you provide a fix?
Much appreciated.

One again you come thru with nice and simple code to do the task.

There is just one wrinkle in this shirt sFix needing to be in order they appear in sInp.

Isnt there a way around that?
I am thinking if the sFix could simply be sorted to the right order at the beginning of the function?
The order the letters are in sFix doesnt really matter for sInp. It merely tells that the letter in sInp cant move.

What do you think?

SHG I really appreciate your help and I want to say a big thank you.

I am frustrated with my code and I was wondering if you could spare a few minutes to take a look at my sheet and perhaps guide me?

On paper it seems a simple thing but right now my code is stuck in a loop and doesnt find any solutions.

Please excuse the mess in the code but I have been trying different things and have not cleaned it up.

TEMP5 is the main SUB that runs the whole thing.
What this code is supposed to do is to parse all the lines in the F column until it reaches an empty cell and then try to replace the letters with digits that will solve the formulas.

Can you take a look and see where I am going wrong with it?
Thanks

Originally Posted by shg

I have no idea what all that means.

What do you need help with?