+ Reply to Thread
Results 1 to 10 of 10

Generate a list of names and dates

  1. #1
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Generate a list of names and dates

    Hi There,

    I have yet another problem I'm hoping for a little help with,

    I have a rather large workbook that is used ti summarise data from a variety of data sources, so far 90% of the process is automated but the most important aspect in my mind remains manual and I would like to remove this element also.

    essentially I will have a unique list of names and a date range, what I would like is for a list two column list to be built with the name in column A and the Date in column B with the name repeated for each date within the range for each name in the list:

    IE.
    Tom 01/01/2015
    Tom 02/01/2015
    Tom 03/01/2015
    Mary 01/01/2015
    Mary 02/01/2015
    Mary 03/01/2015

    Thank you.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Generate a list of names and dates

    Can you provide an example of what the source data looks like?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Re: Generate a list of names and dates

    Here you go.

    Both columns in the live book will be populated by a formula.
    Attached Files Attached Files

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Generate a list of names and dates

    So the list you provided is what you work off of? And you want each name in column A listed for each date of column B? All dates between first in last (date range) or just for every date on the list?
    Last edited by Arkadi; 02-09-2015 at 10:41 AM.

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Generate a list of names and dates

    Kramxel,

    Assuming I understand correctly that you just want a list of each column A member for each instance of column B date, the code below might do it for you, let me know if I was wrong.

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Re: Generate a list of names and dates

    firstly sorry for not getting back to this sooner. i was tied up at work and then had a short absence.

    this works almost perfectly. I just need it to stop when there is a 0 in the date column and move on to the next name, and then stop in entirety when it reaches a 0 in the name column.
    Last edited by Kramxel; 02-16-2015 at 11:31 AM. Reason: BEING A MORON.

  7. #7
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Re: Generate a list of names and dates

    hi Arkadi (or anyone else for that matter),

    is there a way of adjusting the code to stop at the zeros (see my post above)

  8. #8
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Generate a list of names and dates

    Sorry, been away, did you get your issues resolved?

  9. #9
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Generate a list of names and dates

    Here's an alternative:

    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Re: Generate a list of names and dates

    sorry for the delay on this -- column B (the dates) could be of varying length also?

    and I need the values of the cells and the format (date/time etc) copied not the formula?
    Last edited by Kramxel; 04-01-2015 at 04:58 AM. Reason: more data

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA to go through entire list and generate a list of names
    By DadaaP in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-23-2013, 05:09 PM
  2. Replies: 15
    Last Post: 11-28-2012, 03:23 PM
  3. Auto Generate List of Names?
    By rack04 in forum Excel General
    Replies: 3
    Last Post: 12-24-2011, 01:04 AM
  4. How to generate a list of tab names in a summary sheet
    By deanJ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2009, 06:16 PM
  5. Help To Generate List of WorkSheet Names
    By mmcginnis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2005, 08:16 PM

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