I have a master list on sheet, all information is in column A, and based on the first letter of the first word in the cell, for example A1 = Apple, I would like all the text from that cell to be copied into the first empty cell of the sheet labeled 'A' (might be cell A1 in sheet labeled A). Then I need to read the first letter of the first word in cell A2, and it contains 'Bad', I would like all information from that cell to be copied into the first empty cell of sheet 'B'. If the third cell, A3, contains 'Art', I would like the entire cell contents to be copied to, sheet 'A', cell A2 or whatever cell in column A that is the next empty cell.
Is this possible without being a visual basic programmer?
Is this possible without being a visual basic programmer?
