Identical rows based on column A.

[mathsbeauty]

Hello! I am learning macros in excel. I need macro to feet the following situation.
The column A contains numbers. If the number is repeated in this column then it should copy the row which contains the number and paste that row in the cell in which the number is repeated. The situation may look complex but it is not. The problem is simply that "The rows should be identical if they contain the same entries in column A."

 

[mathsbeauty]

You are great Man! You are really great! It works like magic!!! How did you get that kind of excellence in Macros in excel? I also want to excel in macros in excel. How can I start? I do have good knowledge of C and C++ programming languages but not of visual basic or vb.net. Please guide me in short.

 

[mikerickson]

I learned VBA from a book and got experience/practice by answering questions on this forum.

 

[mathsbeauty]

Which Book?

 

[mikerickson]

Walkenbach, "Excel 2003 Power Programming with VBA"
I understand that a new version comes out as they do for Excel.

 

[mathsbeauty]

Thank you mikerickson for all your help. Look to have good friendship with you.