I'm looking for someone to assist me with my excel project. I want a pop form to appear when a cell is selected, to assist enter data in that cell and several other specific cells, either in that worksheet or other sheets within the same workbook. Or create a series of promting messages requiring completion of few other cells if a certain cell is filled, or something similar to prompt users to fill in multiple data in different locations using just one form.
Could all this be achieved by using data validation rather than a macro? You would be able to set the values for the cell, have an input message when the user selects the cell and have an error alert if invalid data is entered.
Best Response confirmed by
Mwandingi_03 (Occasional Contributor)
Thank you for your timeous response. I bet what I want to achieve is too complex for build-in excel functions. I'm leaving it for a while.
By the way, May you kindly assist me with a formula that will return a date in one cell from two cells depending on which cell is filled.
For instance, a date should be returned in Sheet2 A7 from sheet1 A1 if sheet1 A4 is empty (no date filled) or from sheet1 A4 if sheet1 A1 is empty(no date filled) else return an empty cell if both (Sheet1 A1 and A4) are empty.