Formula to Collate Data

[Nova1979]

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.

 

[sandy666]

Duplicate

Collating data

Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without doubling up data. These are 9 digit numbers and some are on the same sheet multiple time and also across multiple sheets ie on sheet3, sheet4, sheet7 but...

www.mrexcel.com

 

[Nova1979]

Hi sandy. Thank you for your suggestion. Due to the system I am using and the security restrictions in place, I can not get access to add-ins. I had a gentleman help earlier and he gave me a macro.
I have spoken to the others utilising the workbook, and I they would idealy like a formula , where people do need to remeber to run the macro.

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.