PLEASE SEE POST #18 FOR UPDATED REQUEST SUMMARY!
I have a situation where clicking buttons determines what data gets entered into Cell B7. The data is collected from one to three other cells on the page, depending on which button was used, and this all works great. An issue arises, however, when there is already data in the B7 cell and someone manually changes the data in one of the three data cells. If they forget to click the appropriate button after that, then the B7 cell displays incorrect data, which is still based on the previous data cell entries.
My question is this – how would I set this up so that when data in one or more of the three data cells is changed and the B7 cell already contains data (from someone clicking the appropriate button at an earlier time) the B7 cell would automatically know which cells it previously received data from and adjust its data accordingly?
I’ve attached an example workbook so you can see how this should work, any help is greatly appreciated!
Bookmarks