Hi,
I am trying to combine the first 2 columns of several ranges on different worksheets but without any duplicates (stacking them, i.e. the resulting range has 2 columns too) and then naming the range.
I am having a lot of trouble with this! I tried several methods, one of which has 2 For loops which deletes a row when a duplicate is found, but I keep getting error messages (something about arrays...)! Please help! I was also putting the ranges together in a primitive way by re-importing the first 2 columns from the original data text files... a more sophisticated way would be much appreciated
Thanks!
I am trying to combine the first 2 columns of several ranges on different worksheets but without any duplicates (stacking them, i.e. the resulting range has 2 columns too) and then naming the range.
I am having a lot of trouble with this! I tried several methods, one of which has 2 For loops which deletes a row when a duplicate is found, but I keep getting error messages (something about arrays...)! Please help! I was also putting the ranges together in a primitive way by re-importing the first 2 columns from the original data text files... a more sophisticated way would be much appreciated
Thanks!