I have a workbook that has two sheets. Sheet 1 is all inventory. Sheet 2 is for the inventory in Sheet 1 that will be shipped to a specific location such as "Aspen Hospital".
If "Aspen Hospital is typed into Sheet 1, I would like all information from that line copied into sheet 2. What...