Can anybody help me understanding the sheet methodology? Any video tutorial might help. One of Chandoo.org user has made it and I am finding difficulty in finding him again. Please help me in understanding the sheet methodology.
Want to color it automatically with reference I just need to put chainage and offset and it should be hatched automatically. Can Anyone Help me? Please use such a forumula so that I can use it on a larger scale with different colors with multiple charts like that. Suppost i have multiple charts...
What is your level of learning as far as VBA is concerned ?
Do you want every line of code to be explained , or are there specific portions of the code which you want explained ?
As far as learning VBA is concerned , there are many good websites which teach VBA starting from the basics ; this question has been asked in this forum earlier , and one such question is here :
Alok Mishra
From my link, You could find 'him' again.
Other case...
... after You have learnt how that works,
then You would figure
that there could be 10000 line data
which should use - as many of Your colleagues has written.
Despite that, it would be good to study.