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.
Bookmarks