Untitled.jpg
So as you can see in the above image, 1st line includes child name and class, and the the second line is the billing line of that kid..
I want the name to get pasted where the 1 is..
However sometimes there will be kids in same family and will have multiple kids..
Untitledss.jpg
So in this as you can see Kamery is listed second but billed first.. so I guess matching the names with column D and then pasting would work..
However there is one more catch..
Untitledasdfa.jpg
In the above Image you can see, that the comment is 3 days.. So sometimes it will appear like this if the child has attended only 3 days.. So matching the names won't work I guess.. In this case the classes could be matched.. so Kayden is Primary A and Jonah is Young Infants..
I don't have a starting macro, because this is way too advanced for my knowledge..
I have attached a template file to work with.. Thanks in advance..
Bookmarks