Macro to sort raw data, remove duplicates and paste 2 specific data on a different sheet

Hello,

Requesting all excel experts for their assistance.

Cross posted -

http://forum.chandoo.org/threads/mac...7/#post-158477

The macro was created with a dummy raw data. It worked perfectly.

Now, the problem is, the code doesn't seem to work with actual raw data.

The code -

Please Login or Register  to view this content.

How the code works -

Raw data is pasted in column R in sheet2.

On sheet1 in cell D2 a row number is inserted. This row number tells the macro from where the raw data in sheet2 needs to be copied from.

Keyword min and max is entered in raw data on sheet2. Keyword max tells the macro till where the raw data needs to be copied.

Let's say, row number entered is 20 and keyword max is on row number 77. Macro copies raw data from cell 20 till cell 76. It will not copy cell number containing the keyword max.

This data is then pasted in column A cell 5 in sheet1, where, macro sorts the data, removes duplicates and splits 2 specific data which are pasted in 2 columns F and G in sheet2 (More precisely from F2 and G2). Keyword min is removed when the sorting is done.

Few things to note -

1) Duplicates are removed based on 6 digit code
2) 2 specific data that needs to separated after sorting raw data are (refer snapshot)

• 6 digit code
• numbers that comes immediately before all the names

I have attached sample sheet with the code

Note -

Sheet2 has dummy raw data based on which the code was developed. Run the macro from sheet1 to get an idea about the end result.

I have included actual raw data on sheet3. I want the macro to work on actual raw data.

Any assistance will be greatly appreciated.

Hi fshbet,

I ran the macro and there are just 2 minor problems -

1) It pastes 5 digit code instead of 6 digit code. Request you to tweak the code so that it pastes 6 digit code as in the snapshot.

2) I would like the data in G column to be centrally aligned.

Except for the above 2 points , macro does everything else PERFECT.

Hi fshbet,

Exactly what I'm looking for.

Thank you for your PATIENCE and TIME...