I need to make my Excel workbook a fully functional data base. Its almost ready, But I could not figure out a few steps. Such as, when I insert(copy-paste) data to my workbook to one of the sheets (Refunds Report Sheet) I need to match values of column A of this sheet with Column B on another sheet (Data Base Sheet) and if its match then write "RECEIVED REFUND" in column Q of Data Base Sheet, and also to check if the amount of refund given and promised had matched as well, otherwise show the difference. In addition I would need to make this workbook looked from accidental changes by user.
Please see attachment. Please note, I would appreciate if you will re-do the file and make it more sufficient.
As an additional task I have an old data base with some data that I need to transfer to this new data base respective and in line with its skus (Column B)
Please feel free to ask me any questions, since I feel my explanation is not clear enough.