Im looking for code that will monitor the E column and whenever the user selects Return from the drop down list it checks to see if there is data in the corresponding I or J cell (on the same row). If so a message comes up letting them know this action will erase data in the 'Item Exchange' and Exchange Unit' cells (I and J). If the user clicks ok it erases those cells, if they cancel the E column goes back to whatever value it started with.
Thanks,
James