Distribute ranges as per Plan

Can anybody please solve it here ?

Hi,

Not too split hairs, but in your request you did not specify the result you expected.
From your request it looked as if you just wanted to do what my code does.
Now in your latest example you show that you want to add the Location to the Start and subtract 1.
This would be the End and in the qty would be the info Ie: "444" in the column for qty.
And as of now it appears that I'm the only one trying to help.
We/I can only do what appears to satisfy your request.
Even now with what you posted I still have a question.
That is in your last sample you show "1027244000" in the Start column.
And in the "End" column you have "1027246187" with a Qty of "2801"
Will you be entering the data? Or, do you want the code to do it?

thanks for your reply, regarding to your question, I would like to say , I will be entering data more if you see data example in my post attached workbook sheet plan, you will find lots of Start and End ranges and from column e you will find distribution plan which result will be displayed in result sheet , if you will see carefully result sheet you will find each ID add and subtract 1 as per given data from column e in Plan sheet.

OK, I see that, but, will you be entering data in all of column A and B, C in the Plan sheet?
And you want the code to produce the result as you indicated in the "Result" sheet?

Yes i will be entering data in al o colun a, b c in plan and code produce result as i mentioned in result sheet

ok,

thanks

You are always welcome charles

Charles, one more thing I would like to tell you which you might not have observed in Plan sheet that there are different ranges of same Prefix those are distributed as per each ID given Qty as mentioned below pic example in highlighted ID range, please see its range distribution

Attachment 493

Hi,

I did not see as you mentioned. Also when looking at your sample how would you know the "E" needs to be entered 2 times.
I do not see any indication it should be done this way.

Because I do work on it , I mean on these ranges , any prefix can have different breakup , I have found some code from a web site through which can read only I'D , a prefix count and zone beside it , if you do not mind , I can share it with a workbook sample and if can you make some amendment to read plan from column e to onward in plan sheet and display result in result ahett instead of plan sheet.