Consolidate Multiple Rows with Match FirstName,MiddleName and LastName with a Unique ID Number

[pab]

Hope!
This would work as you need!.

Thanks so much Sir.

 

[pab]

Hi Sir,

What if I want to combine to fields?

Say New CIF Key plus the Branch Code.

Thanks,

 

[Deepak]

Change this...

.Cells(i, 1) = Sheet4.Cells(Application.Match(m, Sheet4.Columns(5), 0), 1) & "-" & .Cells(i, 4)

Be remember, there is no error handling in the macro. You may add the same as need or something like this.

on error resume next

or

on error goto Err
..........
Err:'add before end sub

 

[pab]

Change this...

.Cells(i, 1) = Sheet4.Cells(Application.Match(m, Sheet4.Columns(5), 0), 1) & "-" & .Cells(i, 4)

Be remember, there is no error handling in the macro. You may add the same as need or something like this.

on error resume next

or

on error goto Err
..........
Err:'add before end sub

Hi Sir,

it showed an erroneous data -

it should be the NEW GENERATED KEY found @ Pre Generated CIF plus BRANCH CODE @ Branch 1 to 30.
Sample:
00001 - 0001
00011 - 0002

Thanks,

 

[pab]

Hi Sir,

it showed an erroneous data -

it should be the NEW GENERATED KEY found @ Pre Generated CIF plus BRANCH CODE @ Branch 1 to 30.
Sample:
00001 - 0001
00011 - 0002

Thanks,

Hi Sir,

The NEW CIF should be a combination of New Generated Key found @ Pre Generated CIF WS PLUS the BRANCH CODE located on every Branch WS.

Thanks,

 

[Deepak]

What do you mean by "BRANCH CODE located on every Branch WS."

Is this sheet name digit or col C value or something else.

 

[pab]

Hi Sir,

If you can see there is a branch code on every Branch Worksheet e.g. Branch 1 , Branch 2. u will add that to the NEW CIF CODE found at the PRE GENERATED CIF WORKSHEET.

Thanks,

 

[pab]

Hi Sir,

If you can see there is a branch code on every Branch Worksheet e.g. Branch 1 , Branch 2. u will add that to the NEW CIF CODE found at the PRE GENERATED CIF WORKSHEET.

Thanks,

Hi Sir,

On every BRANCH WORKSHEET there is a BRANCH DATA e.g.0001,0011 etc. that value will be added on the matching NEW GENERATED KEY found @ Pre Generated CIF worksheet.

It will be
BRANCH+NEW GENERATED KEY
0001-00003

Thanks,

 

[Deepak]

Still didn't get!!

 

[pab]

Sir,

Please check.

Thanks,

 

[Deepak]

.Cells(i, 1) = .Cells(i, 4) & "-" & Sheet4.Cells(Application.Match(m, Sheet4.Columns(5), 0), 1)