Condition to copy cells from one Sheet to another? (Video)

Hello guys!

I tried to search around but maybe I can't be precise on what I want, so I created this video as a visual guide for my question hehehe

VIDEO:

Since I can't post the link here it is not as link, just remove the space before and after the "/"
youtu.be / 0JcFLDPLMlM

Let's start:

I want the Sheet "SA" to have "START" and "END" cells filled with the content of Sheet "Mon-FloorLeader" from Cells: "IN" and "OUT"

only a simple copy I know it's not difficult.... but here it is the catch.
I want to make that copy to be conditional. For example:

If in "Mon-FloorLeader" in the Collum "Associate" the name (in this case NEW HIRE) match with Sheet "SA" Name in Collum "NAME" it will copy IN and OUT from FloorLeader Sheet to START and END in SA Sheet!

And I'll do it for all days of the week in the "SA" sheet matching with "Floorleader" sheet on the days of the week.

I think this explanation with the video help you guys to help me hahahahah!!


Thank you in advance!

Please read the yellow banner at the top of this page on how to attach a sample workbook.

I'll make a guess that it is the single quotation mark before DATA the is the culprit.
Try:

Formula:

Please Login or Register  to view this content.

If that doesn't help then I would suggest uploading the spreadsheet from which the video mentioned in post #1 is made.
Let us know if you have any questions.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)