Sir, i understand that it will take time but it would really be a great help to me as i have got stuck in my works.
for which version width of the column & height of row is suggestible.
What would You mean?
I only figure that if You change any of those
then output would be 'Your like' maybe not wanted!
Mean, do not change!
There is ONLY one cell,
where someone would do setting for 'rowheight'! = 'tmp's Cell A1.
That has depend Excel-version!
I use value 14!
What would mean term 'problem'?
> from some around 200+000 < ... hmm?
1) Start need to be fixed value!
2) The end need to know too!
>> Do someone ever need smaller than ~200+000 values?
it would also work
after add those values to column BY as much needed and
take care that BY10 value is at least max value.
>> Do someone use one file? or many files?
Term 'positive' has many meanings ... I try to give 'soft' reply.
> I made some corrections like ...
> In this strip chart my chainage starts from 220+150 but the boxes is showing some around 226+440, and you can see that the boxes are slightly moved towards right side (image also enclosed).
I checked that file,
question: has someone told to correct eg zoom%?
... No! Let it be 100%! All matters! 100% as below.
View attachment 52655
> when am adding the chainage in output sheet, the file was going hang for few seconds.
If You do same manually by pencil,
how long time it would take to make whole 'output'-sheet?
One sec or few seconds or even more longer?
Many cases, if need to do something more ... it would take longer time.
> I was tried to change the cell value in "BY11" instead of "000+000" with "220+115" it is not allowing when I click on "DO IT".
Hmm.. why did I try to give some hints? and You do something different?
There are rules how this would work!
It's much easier to get wrong result that 100% correct,
especially if not follow rules or hints!
Eg if You write to 'wrong' cell word 'cat' ... maybe it won't work!
Did You read my replies?
Maybe, some of those, You have skipped!
That PRO, who wrote: All i need is to add the required no of layers.
and something in #85 ... hmm? Term 'Soon' seems to be over 48hrs.
More rows means more time.
You cannot select 'start value'!
It could do but as that PRO has asked 'ONLY' something ... but PRO's soon ?
'Start value' modification could take ... time for me + testing...
it's not one minute modification!
Sir i was use the attachment from reply # 84, i was observed that in "output Sheet" on RHS side i was able to change the code but the same time on LHS side was not updating.
Hmm.. what would You try to express?
View attachment 52892
hmm ... maybe ... if You modify those below RHS texts then
need to click LHS and after that RHS to refresh texts.
And Top Level is missing, i mean there is tabular format for both LHS & RHS "Si no., from, To, Code"
Do You mean this which ... is not missing ... or how?
View attachment 52891