I was playing around with a comment adding macro requested by another member
https://www.excelforum.com/excel-pro...t=#post4981390
I I decided as an exercise to try to shorten the code by working out the permutations (First attempt)
I think I have the correct controls in place for the macro to pull the data from columns 5 and 7 into the comment for the correct date but when I extend passed the first 2 rows I seem to tripping over because I must be calling in the wrong order. The furthest I've got is populating the first 4 rows with the correct data.
Would someone with more knowledge of these loops please point me in the right direction.
I should have spent my time working out how to fill them from probably a faster array method but this thing just got stuck in my head...
Bookmarks