1. That is correct
2. No I will have one for July and one for December and that will complete my year
3. That would be ok to have an additional column for invoice number and make all of admiral one contiguous range


your example of B8 AYYY TONNNY!!! if you look on transfer sheet J5 shows 6 from Admiral but since it is on Nelsons sheet that shows that it went to Nelson. I've thought about it some more and I think we can eliminate the choices of "from" in the drop down menus. the reason being is that the location that is highlighted in yellow at the top of each transfer is the location that it is coming from therefore there is no reason to have a choice of "from" in the dropdown.


My overall goal is to fill out the transfer sheet as items are transferred and which location they are being transferred to and from and in the end have a total of how many of which item went to which location and from which location in order for me to better maintain my inventory.


I really appreciate you giving this another try and I also appreciate all of the input you have given me. its really helping me to see what information I really need and don't need. Any way that it can be simplified and still have the same ending result would be fine by me. Let me know if you have any more questions.


Thanks again