Hi there
I would love some help
lets say you have a two column table with kids names in column A and their ages in column B. Some kids are older than ten years old, some are younger.
I want to write a macro that loops through and scoops up all the names of kids that are aged 10 or under. I then want to put all these names into a string like the following:
"Kids aged ten or under are: bob, robert, dan, mike, martha"
This string should then be placed in a cell in column A, 2 rows below the last row of the table.
If you could give me the code it would be much appreciated.
Many thanks
Bookmarks