Results 1 to 5 of 5

Loop through cells and create string

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    San Francisco, USA
    MS-Off Ver
    Excel 2007
    Posts
    60

    Loop through cells and create string

    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
    Last edited by pablowilks; 04-24-2012 at 08:44 PM. Reason: poor formatting

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1