VBA Need help trying to solve, Select data and records in next column the data below the found data od the selected
I have data in column C starting at row 20. I want to select one of the cells in column C;for data, for Example: 1-20-F. once selected I want to run macro that would search in column C for any data with the letter F, once it finds the data with the letter F it will tell me what is found below the data with the letter F. so if 3-15-H is found below the the data with the letter
F it would record it in the D column at the row 20 the letter H, this would continue until there are no more data found with the letter F. I would examine this data then I would start a new search by selecting another cell with data for example 8-46-P. please help as I am stuck! thank you!!!