T
tjtjjtjt
Is there a way to predict the order items will appear in when I use labels to Consolidate
For instance, I have 5 sales reps each trying to sell 10 different products. When we need to consolidate, it's common for the products not to be in the same order on each sheet. Labeling the data (in our case with column to the left) solves this problem, but we can't figure how the information orders itself on the consolidated sheet
tj
For instance, I have 5 sales reps each trying to sell 10 different products. When we need to consolidate, it's common for the products not to be in the same order on each sheet. Labeling the data (in our case with column to the left) solves this problem, but we can't figure how the information orders itself on the consolidated sheet
tj