Merging data from multiple columns into a single list

[vdizzle]

Hello,

Please Help!

I have multiple spreadsheets that contain part numbers.

For example:

Worksheet 1: Column A; contains 200 part numbers .. i.e. BA12345, BA12354, BAxxx.. etc.

Worksheet 2: Column A, contains 300 Part numbers… i.e. BA0987, BA87759, etc

So on and so on…


I need a way to list all of the part numbers from all spreadsheets into 1 list on a separate spreadsheet. What is the best way to execute this?


Thanks

 

[Hui]

Copy Worksheet 2: Column A

goto the bottom of Worksheet 1: Column A

Paste

I'd also add another column first to show which sheet they came from


Then sort the data and check for duplicates

 

[Meedan]

Hui,


I think he is having more than 2 sheets, (So on So on..)


I think a simple macro code would work here for unlimited sheets.

 

[vdizzle]

Yes, I cant do a simple copy and paste operation from multiple sheets and then run a filter to sort. I need to have the master sheet that lists all the part number auto update if any of the part number sheets get changed.