@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..
|