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.
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.
You would probably need to create a for loop within a for loop. Have you watched my series on array? The one with the if statement might help
As a beginner this vid was not that clear, I understand but it was a bit confusing
Until it is demonstrated in a form level like building a module like sum, max, min etc., beginners won't understand