Hi
Here is the next macro for you:
Share ‘Code Appraisal - Drop Down 11 11 xls .txt’ : https://app.box.com/s/jd6mgsnd5mkwuidi2idrpf72a3d91xvq
Share ‘Appraisal - Drop Down 11 11.xls’ : https://app.box.com/s/vuggryhlalxu3qjeztkt2jby3wv9jzoj
https://pastebin.com/Avgsv1h6
https://excelfox.com/forum/showthrea...ll=1#post15118
I expect I may have made some small mistakes. I leave it to you to check thoroughly.
As you suggested, it is tedious work. But if you approach it carefully, it is not difficult.
Here some of the notes I made as I went along
https://excelfox.com/forum/showthrea...ll=1#post15114
https://excelfox.com/forum/showthrea...ll=1#post15115
https://excelfox.com/forum/showthrea...ll=1#post15116
https://excelfox.com/forum/showthrea...ll=1#post15117
Some extra suggestions
I showed you yesterday, ( Sub MakeNormalDropDowns1x4andLoop4times() ) how we can approach things slightly differently using looping and offsets.
There can be a couple of advantages to this:
_ 1. It looks a bit simpler and tidier ( it may not finally work any better )
_ 2. In some cases it might make further additions to data easier…
In order for this to work, it would be very helpful if you could have a regular structure in your data
For example, your Comment worksheet should be structured so:
Share ‘Some extra suggestions.xls’ : https://app.box.com/s/ux77egbft9kipdtiht21017y4iixp854
Similarly you should structure your Advice worksheet in a similar, regular, way.
Such regular structures would allow the easier implementation of the looping and Range.Offset coding ideas
That is just something for you to consider in the future
( When you have your final solution it would be courteous and helpful to others if you could share your solution )
Alan
Reply With Quote
Bookmarks