eliminate duplications

[shortman_alan]

hello,
im sorry for posting so many threads but i am getting nowhere very fast with this particular project.

i would like to develop a macro that will prevent duplications of titles.
for example when a title of "cutter" is entered as well as "cutters" or "end scraps" and "End Scraps" are entered they will be combined and the data that they are the heading for are kept under the same heading. i would imagine this would be kinda simple but i am just unsure how i would go about it as it would end up slowing down the code a fair bit using autofilters and such in the macro.

cheers!

[gummi]

hello,
im sorry for posting so many threads but i am getting nowhere very fast with this particular project.

i would like to develop a macro that will prevent duplications of titles.
for example when a title of "cutter" is entered as well as "cutters" or "end scraps" and "End Scraps" are entered they will be combined and the data that they are the heading for are kept under the same heading. i would imagine this would be kinda simple but i am just unsure how i would go about it as it would end up slowing down the code a fair bit using autofilters and such in the macro.

cheers!

It would be easy to make a macro that checks for duplications, but you're looking for a macro that looks for similar data...

anyway... you can use the

Please Login or Register  to view this content.

This code will NOT work straight, as I've no-idea how your data looks like and I'm doing this only from my mind, there's bound to be syntax errors, and most likely logic errors also. But it might go somewhere around this. (this checks the duplicates)

To check similarities, you have to check if you can 'FIND' a header you just created from any other header, or if you can find any other header in the header you just created.


It's doable, don't give up.