Could someone please help? I am trying to pull column data from multiple sheets (24 I total so far) into 1 master sheet without doubling up data. These are part numbers. Some are on the same sheet multiple times and also across multiple sheets
Reference Sheet1 (same number same sheet)
Reference Sheet2 (same number listed in sheet1)
Master (result)
As can be seen, I need column A sorted numerically, and the expanding columns of B (there other things than X) and C to move accordingly with the data in column A. I am unsure if this can be done using formula.
Reference Sheet1 (same number same sheet)
Reference Sheet2 (same number listed in sheet1)
Master (result)
As can be seen, I need column A sorted numerically, and the expanding columns of B (there other things than X) and C to move accordingly with the data in column A. I am unsure if this can be done using formula.