How to do this in Microsoft Excel
Posted on 2016-09-25
First Tab - Master customer data file. Tab Name = "MASTER"
Second Tab - specific data for an individual customer. Tab Name = "13 n clark"
Goal: How do you automatically populate the 2nd tab from the data in the first tab with the knowledge that the values in the "ID SMK" column under each subgroup may change. Specifically meaning that under the "13 n clark" customer, "B2323" may be under a different customer the next month AND there may be more or less ID SMK's underneath "13 n Clark" the next month as well.