I have a a spreadsheet that I keep for location inventory of tooling (cutting dies for a press). In the first sheet(Master), customer service inputs the new tooling that comes in and all the information that is associated with that cutting die. We have 3 different machines so we have different location for all three. The issue is that our ISO states that we have to issue these cutting dies numbers when they come in and they get the next number in line. 998 999 1000. The only thing that designates the difference is a two character designation. One machine is RB and another is RC and another is RJ. Say we get an RJ and an RB cutting die in. One would be RC-998, and then the RB would be RB-999. In the next three sheets besides the master RC, RB, and RJ with location numbers. All three location start with 001 and go up. I need to make this as simple as possible for Customer Service. Is there a way that they can just input all the information into the master file and the other three sheets can automatically populate with the correct location for that new die.
Can this be set up as if one cell has RB and the location is 115 then it would copy the whole row from the master into the correct location on the right sheet for that machine? That way we can filter the information on the Master File if we need to look up old Cutting Die information but we can go to the other three sheets to get a snapshot of the what the current inventory is?
Bookmarks