Hello,
I have 5 checkboxes in my sheet in rows A4 to A8. I have attached the sheet. if user selects the check box the below values should be displayed.
1. Selects checkbox 1 in collumn A4, then value 1.5 from column E4 should be automatically populated in collumn B4 with heading named values
2. Selects checkbox 2 in collumn A5, then value 2.3 from column E5 should be automatically populated in collumn B5 with heading named values
3. selects checkbox 3 in collumn A6, then value 0.25 from column E6 should be automatically populated in collumn B6 with heading named values
4. selects checkbox 4 in collumn A7, then value 5.9 from column E7 should be automatically populated in collumn B7 with heading named values
5. Selects checkbox 5 in collumn A8, then value 1.8 from collumn E8 should be automatically populated in collumn B8 with heading named valueds
Please help with the formula/macro for this.
Thanks and Regards,
Santosh
Bookmarks