Matching Input Date and Copying & Pasting to Another Sheet

[r2yneth]

Hello!

I am running into an issue to turn a data validated cell into a string that matches the same date on another sheet in the same workbook.

Currently I have my data validated cell as a drop down from 1/1/2019 to 12/31/2019 and on the second sheet it is an entire column from 2-366 for every single day (with date header)

I would like to get the initial data validated cell to turn into a string and match with the same date on the second spreadsheet (correct row). Once a match has been found, it will paste the data from the first spreadsheet into the correct row that has been determined.

Any help would be greatly appreciated!

 

[Rijnsent]

Hi r2yneth,
could you paste the code you already wrote here, that would help us helping you. If you don't have that much code, e.g. fill it up with pseudo code where you describe step by step what needs to happen.
Thanks,
Koen