slapaks
04-10-2014, 12:48 AM
Sheet1
A
B
C
primary
primary
primary
secondary
secondary
Sheet2 (This is in different sheet )
A
B
C
Primary
Secondary
Hi everyone.
I need a macro that copy and ignore the duplicate of primary in sheet1 column A to another sheet (sheet2) column B. and also copy secondary (same ignore duplicate) in sheet1 column A to sheet2 column C.
A
B
C
primary
primary
primary
secondary
secondary
Sheet2 (This is in different sheet )
A
B
C
Primary
Secondary
Hi everyone.
I need a macro that copy and ignore the duplicate of primary in sheet1 column A to another sheet (sheet2) column B. and also copy secondary (same ignore duplicate) in sheet1 column A to sheet2 column C.