I'm looking to copy specific text from R5:AC5 to the first blank cell in column B after matching the text in R5 with text in column B
R5=Apples
B1= "Apples"
B2= Random alphanumeric
B3= Random alphanumeric
B4= Blank
B5= Random alphanumeric
R5:AC5- various alphanumeric text.
This would be copied into B4 since it is blank.
Thanks!
Bookmarks