Extract Unique Items

Hi,

I am working on a workbook that contains more than 50 worksheets. One of my tasks is to extract unique items from Column G Row 5 from all of the 50+ worksheets. Could someone provide a macro that I can use to perform this task? Or any other ways that can speed up the work.

Thanks in advance!

Actually I want to extract all the unique items from Column G from all of the worksheets within the workbook and copy it to a new worksheet within the same workbook.

Hi

The following assumes that the output sheet already exists, and is the first sheet in the workbook. The remaining sheets (2 - 51) will be processed. The output will be placed in column A of sheet1, starting in A1.

Please Login or Register  to view this content.

If you already have data in the first sheet, then it will have to be removed before processing.

hth

rylo

Originally Posted by rylo

Hi

The following assumes that the output sheet already exists, and is the first sheet in the workbook. The remaining sheets (2 - 51) will be processed. The output will be placed in column A of sheet1, starting in A1.

Please Login or Register  to view this content.

If you already have data in the first sheet, then it will have to be removed before processing.

hth

rylo

Thanks, rylo! It works!!!
I also changed your code 'For i = 2 To Sheets.Count' to
'For i = 5 To Sheets.Count' for the macro to start extract the unique items from sheet 5 [skipping sheet 2 to sheet 4] and it also works! This is awesome. Thank you once again!