Good morning to all,
I'm looking to remove unwanted records from my excel file. I know that the first cell I want to save contains the word "From". All other records above that cell I want to delete. For example:
A1 cell contains "Today is Friday"
A2 cell contains "123456"
A3 cell contains "From"
A4....A20 cells contain "Good Data"
I would like to remove all records until I reach a cell that contains "From" in column A. So, I would like to loop through all the records until I find "From". In the example above, I want to remove the first two records, and save all the records starting with the "From" record. So after removing the unwanted records, I would be left with:
A3 cell contains "From"
A4....A20 cells contain "Good Data"
Hope this makes sense. Thanks in advance for any assistance. I've used this board in the past, and you guys ROCK!
Mike C.
I'm looking to remove unwanted records from my excel file. I know that the first cell I want to save contains the word "From". All other records above that cell I want to delete. For example:
A1 cell contains "Today is Friday"
A2 cell contains "123456"
A3 cell contains "From"
A4....A20 cells contain "Good Data"
I would like to remove all records until I reach a cell that contains "From" in column A. So, I would like to loop through all the records until I find "From". In the example above, I want to remove the first two records, and save all the records starting with the "From" record. So after removing the unwanted records, I would be left with:
A3 cell contains "From"
A4....A20 cells contain "Good Data"
Hope this makes sense. Thanks in advance for any assistance. I've used this board in the past, and you guys ROCK!
Mike C.