So I am trying to get the following If then else statement to work. I believe I am having the most difficulty in getting the embedded loop to loop (the "else" part of the macro)
I believe the code shows what I am trying to do pretty clearly, which is if a cell in sheet1 equals a cell in sheet 2, make the original sheet 1 cell equal to a cell in sheet 2. the Part I am having trouble with is that if the cell doesn't equal the cell in sheet2, I want it to continue going down the list until it hits the cell for which it is equivalent.
Here's my Attempt at a Select Case way of doing this (also doesn't work but looks much cleaner)
Bookmarks