Hi Excel gurus,
I have a conundrum I need solving (I have been working on it for at least 48 hours!
On worksheet 1, I have an array which is comprised of multiple columns and rows and each cell in the array is populated with a date. The dates represent dates of bonus payments made to Colleagues. The colleagues names are in the column at the farthest left side.
On worksheet 2, I have a table which has a header row of individual sequential dates and eventually a number of rows beneath.
I would like the table on Worksheet 2 to automatically list all of the names relating to the individuals who have been paid on the date that is in the respective header.
"Easy!" I hear you say, not for this numbskull!! Please help?!?
Many thanks in advance.
Sheet 1:
Sheet 2:
I have a conundrum I need solving (I have been working on it for at least 48 hours!
On worksheet 1, I have an array which is comprised of multiple columns and rows and each cell in the array is populated with a date. The dates represent dates of bonus payments made to Colleagues. The colleagues names are in the column at the farthest left side.
On worksheet 2, I have a table which has a header row of individual sequential dates and eventually a number of rows beneath.
I would like the table on Worksheet 2 to automatically list all of the names relating to the individuals who have been paid on the date that is in the respective header.
"Easy!" I hear you say, not for this numbskull!! Please help?!?
Many thanks in advance.
Sheet 1:
Sheet 2: