Edzila
New Member
- Joined
- Jul 12, 2020
- Messages
- 5
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
- MacOS
- Mobile
- Web
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)
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)