Hi
I have 2 files 1st one has data and in 2nd product details & MRP had been mentioned I have to map the data and in the 1st file there are transaction type for which i want that for Shipment the value will be negative and for refund the value needs to be negative.
Please refer Sheet1 as 1st
Sheet2 As 2nd
Sheet3 will be the output
So mainly need the help for hoe to change the Number as per Transaction Type and also in Total MRP.
