Macro to compare "main row"

[bb86993]

Hello to All
Urgent help needed
1. Workbook (two sheets with numbers)
2. User manually selects range of cells (numbers in same row but different columns)
Example (main selection):
c d e f g h i j k l
1 2 3 4 5 6 7 8 9 10

3. Macro checks both sheets, compares "Main Selection" with other rows and highlights "doubles" (including "main selection")

Example rows (could be different length):
1) 2 5 7 15 27 56 47 74 85 1 10... (2,5,7,1,10 would be highlighted)
2) 1 3 8 4 22 33 55 90 10 6 7 9... (1,3,8,4,10,6,7,9 would be highlighted)

I found macro to compare ActiveCell but don't know how to modify it accordingly. Too far from programming

Sub HighlightCells()
ActiveSheet.UsedRange.Cells.FormatConditions.Delete
ActiveSheet.UsedRange.Cells.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:=ActiveCell
ActiveSheet.UsedRange.Cells.FormatConditions(1).Interior.ColorIndex = 4

End Sub

Thank you in advance
Your help is very appreciated

 

[sergioMabres]

Done see test book
https://dl.dropboxusercontent.com/u/23094164/Boris2.xlsm
Cheers
Sergio

 

[bb86993]

I think it's working
We'll keep you posted

Thanks
All the best

B.

 

[bb86993]

Hi Sergio,

Long time no see
Have another "project" if you're willing to help
Data: a lot of rows but only 7 or 8 columns
1 2 3 4 5 6 7 8
9 10 11 12 13 14 15 16
17 18 19 20 21 22 23

I'd like to choose and combine multiple rows into one row with initial data intact (something like "cut & paste")
1 2 3 4 5 6 7 8 17 18 19 20 21 22 23 (always maximum 21 cells in a row)

Thank you in advance

B.