stevembe
03-11-2014, 07:11 AM
Thanks for taking the time to look.
I have two columns, one labelled Current (A1) and the other labelled Proposed (B1). What I am trying to achieve in the columns underneath is force the user to enter data in the Current column if they have entered data in the Proposed column as quite often they leave it blank so basically if the right cell is populated then the one to the left needs to be and if it isn’t a pop up message appears telling them they need to.
Any assistance would be greatly appreciated.
I have two columns, one labelled Current (A1) and the other labelled Proposed (B1). What I am trying to achieve in the columns underneath is force the user to enter data in the Current column if they have entered data in the Proposed column as quite often they leave it blank so basically if the right cell is populated then the one to the left needs to be and if it isn’t a pop up message appears telling them they need to.
Any assistance would be greatly appreciated.