Distribute ranges as per Plan

[ayazgreat]

kinldy help to resolve it

[Charles]

Hi,

I was able to modify the code in one of your files.
If you change the "Location grid" range the code will need to be updated.
If you plan on this let me know and I'll modify the code so that it may not be necessary to update.

[ayazgreat]

Charles how should I change location that helps you modify code where do you want to keep location grid

[Charles]

Hi,

THe "Location" grid starts in column "F" thru "U". The way I had the code set was to go
"F to "U" and if you added another column say "V" then the code will not work properly because I
pre set the range to "U". In this copy I changed the code so that if you added more columns the code will see it
and not fail. In column "F" you have the "Alpha" characters. If you add more to this the code should still work.
It was the matter of extending the "Columns".
I did not test for this, but you can and let me know.

[ayazgreat]

Wooo, it is amazing you did it what I required, by modifying my provided code, i am very glad , thank you very much Charles, i really appreciate your efforts and time invested by you to resolve it.

[Charles]

Thanks for letting me know.