I been trying to find a way to somehow skip formula. I have sheet one which has option to select different buildings and only building 1 have manpower number. Sheet two is suppose to let others fill-in number of manpower for Building 2 as needed in column B -Sheet 2. BUT populate Building 1 manpower from sheet 1- if building 1 is selected in sheet 1. I tried conditional formatting using if formula but it doesn't bring me result. I don't know any other way. Can someone help to either write a Macro? I don't want to put formula in Sheet 2-column B because anyone beside building 1 have to manually add number of employees. MUCH MUCH Appreciated. See attachment.
Bookmarks