Copy Data if the Date Matches to Another Workbook

[Kate Borders]

Hello!

I've searched through a lot of threads, and haven't been able to find what I'm looking for, but I apologize if this has been asked before. Also, I'm not the best at coding, so just be aware.

I would like to have something that will look at the "Date Samples Started" (Column X) of the general workbook, compare that date to the date listed in cell A13 of the new workbook, and then copy the "Sample Number" (Column W)- if it has the same date associated with it- to the new workbook, between cells C9:C46. Please let me know if that's not clear.

I greatly appreciate your help!

 

[Deepak]

Pls share the sample workbook to get it out.

 

[Kate Borders]

Oh, sure!

I'd like to take the info from Book2 to DataFillBook.

Also, I'd really appreciate if whoever helps me to explain how/why they do it this way. I've tried a bunch of code the past eight hours, and I'm obviously missing something.

Thank you!

 

[XLPadawan]

Oh, sure!

I'd like to take the info from Book2 to DataFillBook.

Also, I'd really appreciate if whoever helps me to explain how/why they do it this way. I've tried a bunch of code the past eight hours, and I'm obviously missing something.

Thank you!

Kate Borders,
I included my commentary in the workbook I uploaded. Let me know if I've left any questions unanswered.

 

[Kate Borders]

That works beautifully! Thank you very much for your comments on it, too. That definitely puts it all into perspective.

Thanks, again!