cell changed in one sheet look up and update a cell in another sheet

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

It is always easier to help and test possible solutions if we could work with your actual file. Perhaps you could post a copy of your file. De-sensitize it if necessary. Include a detailed description of what you want to do using a few examples form your data and referring to specific row, cells and sheets.

Hello,
I attached a copy of the file
If I add a new transaction on the second sheet (like purchase) and select Yes for the field Apply, I need the stock on the first sheet to be updated.
Thanks

So would the transaction described cause 15 to be added to the Quantity in stock??

Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your "Transactions" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter your data in columns A, B, C and E and enter the quantity in column D last and exit the cell. The quantity entered will be subtracted from the quantity in "TCM". Before you do all this, the tab name "TCM" has a space at the end. Remove that trailing space in the tab name.

Please Login or Register  to view this content.