Hi,
I have several excel spreadsheets with around 15 to 20 sheets with data I have extracted at around 30,000 lines per sheet. I need to remove the duplicate rows. The duplicate data sits in column B. I looked at autofilter and its not really an option given the number of files and sheets I need to look at. Is there anyway where vba may be able to help?
Data:
any ideas?
vaneagle
I have several excel spreadsheets with around 15 to 20 sheets with data I have extracted at around 30,000 lines per sheet. I need to remove the duplicate rows. The duplicate data sits in column B. I looked at autofilter and its not really an option given the number of files and sheets I need to look at. Is there anyway where vba may be able to help?
Data:
Code:
Row Col B Col C
1 217.1 217.1
2 217.1 217.1
3 231.1 231.1
4 231.1 231.1
5 448.2 448.2
6 142.56 142.56
7 142.56 142.56
8 142.56 142.56
9 119.52 119.52
10 690.46 690.46
11 1465.69 1465.69
12 783.07 783.07
13 2535.9 2535.9
14 176.55 176.55
15 968.55 968.55
any ideas?
vaneagle