Macro to compare date in number and product

K0st4din

Active Member
Joined
Feb 8, 2012
Messages
488
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
Hello everyone.
I have another problem with my previous file that I need to finish.
Because I want to make it clear I'll attach the files and pictures before the middle, and what can be the end of this table.
I would be very grateful if you assist in this task with a macro.
7076329I.jpg
7076330a.jpg
7076331X.jpg
7076333a.jpg
File to download
 
Hello
I beg you if you could change a little this macro ?
1 - st - can you tell me if I should change something in it, because I feel like I enable it if the file has more than 20 000 lines removes duplicates , but I have to press several times the button (that it's like it clears the repetition of steps ) ?
What can change it (add) following comparison of the lines in the specified cells again to delete duplicates , but to delete the rows of A to X ( ie after the X to delete the rows I do not ( because after X got texts (information ) that should not be deleted) ) ?
I would be very grateful if you cooperate.
7093157I.jpg
7093158d.jpg
I mean, this deletion be a in the macro
 
Upvote 0

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Friends know I have to wait because you may be busy, but I really was very urgent, tomorrow I will have to deal with.
I am extremely grateful for your cooperation.
 
Upvote 0
Friends, can someone make a slight change?
 
Upvote 0
Can anybody look and help me?
Please someone for assistance.
 
Upvote 0

Forum statistics

Threads
1,216,150
Messages
6,129,154
Members
449,488
Latest member
qh017

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top