EBERHARDTJOEY
New Member
- Joined
- Feb 24, 2025
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Im trying to figure out how to get sheet 1 to auto fill a cell with yes,no if multiple cells on sheet 2 are selected yes,no.
example
cell a1 sheet 1 yes
cell a2 sheet 2 yes
cell a3 sheet 2 yes
cell a4 sheet 2 yes
cell a5 sheet 2 yes
cell a1 sheet 1 no
cell a2 sheet 2 yes
cell a3 sheet 2 no
cell a4 sheet 2 no
cell a5 sheet 2 yes
cell a1 sheet 1 no
cell a2 sheet 2 no
cell a3 sheet 2 no
cell a4 sheet 2 no
cell a5 sheet 2 no
example
cell a1 sheet 1 yes
cell a2 sheet 2 yes
cell a3 sheet 2 yes
cell a4 sheet 2 yes
cell a5 sheet 2 yes
cell a1 sheet 1 no
cell a2 sheet 2 yes
cell a3 sheet 2 no
cell a4 sheet 2 no
cell a5 sheet 2 yes
cell a1 sheet 1 no
cell a2 sheet 2 no
cell a3 sheet 2 no
cell a4 sheet 2 no
cell a5 sheet 2 no