I have a workbook that is created of inventory items at work. I have a data sheet where I enter information about items I have to add to the inventory room. On this sheet I have the first column as the customer followed by the part number, revision, quantity, cart number and specific shelf location. Then I have 4 sheets following the data sheet that make up the 4 cart locations. I want to be able to have excel auto place the entries I make on the data sheet to the correct sheet for the corrosponding cart number entered tin the first blank cell at the end of the listed parts under that specific customer. The 4 different sheets folowing my data sheet are named "Cart 1, Cart 2, Cart 3, and Cart 4. All these sheets have multiple shelf locations and multiple customers with parts listed under them. There are a couple cases where custome parts are located on more then one cart and even different shelf locations so I need to be specific with where I want my data sheet entries to copy to. At some times I think I need to use an if function with multiple conditions in code somehow but I cant seem to figure out just how to code this. I have tried to cut and paste from many other forms the pieces I think will benifit my task however I have not been able to piece together a working VBA code to suit my needs. This sounds like WAY too much information and confusing as ever but I hope someone might be able to help me find a VBA code to help with me. Hope this question isnt too confusing.
Thanks for any help. It will all be much appreciated!