Destination cell is empty after copy and paste

Hi,

I have been trying to copy and paste the names from a roster based on the date entered into an input box. I would like to look up the date in a row and use that column to search for certain shifts, then copy and paste the name in column A to a different location. All seems to work ok but the destination is selected but empty.

Any help would be gratefully appreciated...

Please Login or Register  to view this content.

Roster.xlsm

I am trying to select the column based on the date and then when the cell relate to a particular shift I want to copy and paste the name in column A to a different location, this may be a different sheet in the workbook.

Thanks