I need to copy the text from sheet 1 (Inspection) to sheet 2(results) in the form of a list. So, sheet 1 F313:F337 needs to have the text copied to sheet to Sheet 2 B3:B27. However, if, for example, I only have text in sheet 1 F313, F319, F336, I only want to copy those 3 cells to sheet 2...