Issue with Macro

[jlsfagan]

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 delted and not sent to the other page h

UAB 4 ave warehouse inventory.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	UAB Warehouse Data base
2	Date updated:2-3-23		Item
3	item Number	Manufacturer	Task Chair	Task Stool	Guest Chair	Overbed Table	Bed Side Table	High Back Patient guest Chair	Recliner	Sleep Chair	Sleeper/sofa	TV/wardrobe	Drum table	PED	Monitor Arm	ICE Machine	Large national CPU holder	Trash Cans	Lockers	Christmas Trees/items	Original Location	Workorder	New location	moved
4	1	Kwalu										x									WH
5	2	Kwalu										x									WH
6	3	Kwalu										x									WH
7	4	Kwalu										x									WH
8	5	Kwalu										x									WH
9	6	Kwalu										x									WH
10	7	Kwalu										x									WH
11	8	Kwalu										x									WH
12	9	Kwalu										x									WH
13	10	Kwalu										x									WH
14	11	Kwalu										x									WH
15	12	Kwalu										x									WH
16	13	Kwalu										x									WH
Inventory

ad we not made sure on that specific instance.

 

[jlsfagan]

UAB 4 ave warehouse inventory.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	UAB Warehouse Data base
2	Date updated:2-3-23		Item																		Location
3	item Number	Manufacturer	Task Chair	Task Stool	Guest Chair	Overbed Table	Bed Side Table	High Back Patient guest Chair	Recliner	Sleep Chair	Sleeper/sofa	TV/wardrobe	Drum table	PED	Monitor Arm	ICE Machine	Large national CPU holder	Trash Cans	Lockers	Christmas Trees/items	Original Location	Workorder	New location	moved
4	18	Stryker				x															WH		WP 7	x
5	19	Stryker				x															WH		WP 7	x
6	20	Stryker				x															WH		WP 7	x
7	21	Stryker				x															WH		WP 7	x
8	22	Stryker				x															WH		WP 7	x
9	23	Stryker				x															WH		WP 7	x
10	24	Stryker				x															WH		WT 7	x
11	25	Stryker				x															WH		WT 8	x
12	26	Stryker				x															WH		WT 9	x
13	27	Stryker				x															WH		WT 10	x
14	28	Stryker				x															WH		WT 11	x
15	29	Stryker				x															WH		WT 12	x
16	111	Safeco																	x		WH		NP 6	x
17	112	Safeco																	x		WH		NP 6	x
18	113	Safeco																	x		WH		NP 6	x
Move out

 

[jlsfagan]

 

[jlsfagan]

The first picture is my worksheet 1 and second picture is my worksheet 2. The third pic is 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.