Hi Sharma,
Thanks for extending your kind help.
I have emailed you with "example sheet" in attachment
plus i have rephrased the problem many times to make it really easy for you.
looking forward to your reply
thanks in advance
Tia jOY
Thanks hui and vijaySharma for Warm Welcome and kind help
I Read your your message the moment you posted it
I Know little about Excel VBA and i don't understand your code.
I feel like being pest to ask you to explain the code.
I pasted your code in VBE and run it but nothing happens.
I...
Is it possible for human race to come up with macro for excel 2007
which can check for duplicate and copy the format and whole row of original and paste it over duplicate/ duplicates.
Question for Advance Gurus:
Can i set range of cell to be copied from orginal to duplicate/dulicates
e.g...