Duplicate Data when a checkbox is checked.

[Edzila]

Based on the example below... I need to create a formula or function that when I click the YES checkbox the data from 'D' (in the same row) is copies to 'G' and when NO is checked the data from 'D' is copies to H

I'm hoping this can be done without needing to specify the rows because my dataset is 600 rows long and I really don't want to edit 1200+ cells manually.

All help us appreciated. Thanks in advance.

Also note, that ultimately this will be a shared doc in Microsoft 365, so it will be running in Excel Online. (I have created it in Excel 2019)

 

[Fluff]

Glad we could help & thanks for the feedback.