Populating data from row into a calendar format

Hello to my favourite forum when I'm stuck with something.

I have an excel sheet in which our staff roster for a month is spread in a row, column indicating the date. We have some 200 staff so its like 200 rows of such data. What I current have done is when i select a cell which a staff name under column C, and press the send button, it pick that entire row for that staff roster and emails it to them.

what I am instead wanting to do is, when I select the name of a staff in Column C and press a button, it should pick the shift codes under each date and populate in a calendar format. I tried scribbling something with the code but couldn't even come close

I'm attaching both our roster format and the calendar format in here. I can take care of the covert to pdf and emailing part, just cant get to populating the row data in the calendar format.

would be grateful as always for assistance.

OMG! thot I had removed the password. heres the file again.
and thank you very much

Hi,

Give this a try:

Please Login or Register  to view this content.

Hope it works for you.

Cheers

Hi,

Give this a try:

Please Login or Register  to view this content.

Hope it works for you.

Cheers

and it has worked!!! thank you so much.

Glad I could be of some assistance.

Cheers