Repeating a list of data x number of times

JohnnyMike - Jan 16, 2015 at 09:56 AM

I'm working on an agent daily activity sheet and need to put together a sheet that will grab a list of ID#s then repeat for the number of working days in the quarter.

My list currently contains 27 different ID numbers and I need to see the 27 for each working day. For example, if I have a list of ID#s on one tab, on the summary tab, I need to pull in the full list of ID#s for each working day:

ID# Working Day
ID1 1/5/2015
ID2 1/5/2015
ID3 1/5/2015
ID1 1/6/2015
ID2 1/6/2015
ID3 1/6/2015
ID1 1/7/2015
ID2 1/7/2015
ID3 1/7/2015
and so on...

Is there a way to use a formula that refers to the ID list, pulling in all 27 IDs then starting over with the first ID and the rest of the entire list for the next working day, but will be able to adjust if an ID gets added to the list of IDs?

I currently just pasted the list of IDs in for the first day then referred back to the first ID from the first day when starting on the second day (=A2), but I was hoping there would be a way to grab from the list and start over once all those on the list have been grabbed so that it would automatically adjust for any additions to the list.