Excel move row issue

Question

I have created an excel spreadsheet showing a list of inventory. I wanted to be able to put an X in the final column to provide an easy move to the out page. This will let me know when thing are taken out of the warehouse. I have created both worksheets. I even got the code and them up and running. The issue is now some of the rows do not move to the other page they just delete. Please help because we would not have know something got deleted and not sent to the other page had we not made sure on that specific instance.

The first my worksheet 1 and my worksheet 2. The third my code. Like i said the code is working, but for some reason not working on all rows. Some of the rows are deleted and moved when i submit the X, but others are just deleted. I need each row deleted from workbook 1"Inventory" and moved to workbook 2 "Moveout". Also another issue I have is when we need to add more columns for other inventory items this messes up the code location column "x". I was thinking i could just make a bunch of extra columns and hide them.

Answer 1

Could you share us your workbook with some dummy data for testing? You can use dropbox or OneDirve to share it.

You can also share it via private message by clicking the icon below.