Hey Chris really enjoy all of your videos. I was trying to see if you could do a video related to this problem. Say on sheet1 in column (A) you have numbers and alphanumeric numbers in order which could be 10 rows. The numbers include 1,3,7,2A,3B,5C,7D B, D, E. On another sheet like sheet2 there are 5 values in column A. These values are mixed and include in this order 4, 5, 1A,6D, A. I am trying to insert these values in sheet 2 into the column B in sheet1 in numerical, alphanumeric, Alphabetic order in relation to the values in sheet1 column A. I am still fairly new to VBA and have been able to do this when there are only numbers. I cannot figure out how define inserts for Alphanumeric or Alphabetic values.
