Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Loop through data to copy to other sheets.

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    359
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, Jay.

    What's HTH mean? "Hard to handle"?

    Edit: "Heart to Heart"?

    [ This Message was edited by: Cosmos75 on 2002-04-16 14:40 ]

  2. #12
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    HTH -- Hope this helps

    HTH,
    Jay

    [ This Message was edited by: Jay Petrulis on 2002-04-16 14:47 ]

  3. #13
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jay:

    Have to let you know: The user loves her new vacation workbook.


    ~Anne Troy

  4. #14
    Board Regular
    Join Date
    Nov 2004
    Posts
    156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [/quote]

    Hi,

    Short answer:

    1. Get a list of unique names and add a sheet, then name it the person's name

    a) advanced filter and cycle through the list

    b) loop through the list of names and determine whether the sheet exists or not. If it does, go on, else add the sheet.

    2. Cycle through the data list and add each item to the appropriate sheet. You will match the name in the cell and transfer the data to the relevant sheet.

    These two can/should be separate routines as you will only have to add sheets initially and/or when new people are added.

    [/quote]

    What you just described is exactly what I need. But I have no clue how toget there.... Did anyone manage to get there? Would be ever so grateful....

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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