@purleet..

Great this looks like it would work. It is not moving any other rows or columns which is exactly what i need. So I like the idea.. My workbook is a little more complex because it has text above the names so I am going to attach the workbook here.

Also the name entry would be on the tab called take orders and then fill the name on the other 3 sheets to the left.

Thanks for offering to help. I am not a great coder..

Attached Files

Show and Sell Inventory Template.xlsx (16.2 KB, 9 views)