PDA

View Full Version : Delete duplicate merged rows.



fatalcore
02-02-2012, 12:06 AM
Hi,

I need some help in these two points.

>>>Button : Create repetation

1.I am using a code to generate number of repetation. The problem is when I am running the code i am getting strange errors. Like the number of repetations is inserted in sheet "Face". Then I am pulling the data to "before" sheet.
and then running the code.I am highlighting the cells in RED where the errors are cropping.

>>>Button : Delete repetation

2.I also want a code that will delete the entire duplicate row based on Column F also the linked pages under column L if any.

Thanks in advance for all your help.

Bob Phillips
02-02-2012, 05:59 AM
The data is duff. D20 contains #REF! which throws the code.

fatalcore
02-02-2012, 06:25 AM
Hi xid,
I could not understand what you meant,can you please help me out.
Thanks in advance.

Bob Phillips
02-02-2012, 06:51 AM
Try running your code, you will see what I mean.

fatalcore
02-02-2012, 08:29 AM
That is the problem, I don't know what to modify and where the problem is happening. If I know coding I could have understood. Can you please edit the code.
Thanks in advance.

Bob Phillips
02-02-2012, 11:55 AM
It is not the code, at least it may not be, it is your data that is duff. Until you correct that there is no point running any code.

fatalcore
02-02-2012, 10:13 PM
But that is exactly the way I want it.I mean the data...

Bob Phillips
02-03-2012, 03:53 AM
What, you want data that is just errors? Sorry that makes no sense.

fatalcore
02-04-2012, 10:21 AM
Hi Xld,
I am unable to clearly define the problem, I will give it a try once again, I have marked in yellow how the numbers are flowing. Hope it helps.
Thanks in advance.