I have appoximately 50 html files that I would like to copy/import 1 at a time into a worksheet called "raw". Each time a file is imported I would like to remove rows 1, 3 to 5 and 9 to 21. Once these rows have been removed I would like to copy this data to a worksheet called "complete" and move onto the next html file.
Each time the "raw" worksheet would need to be blanked and every time I copy the data from "raw" to "complete" I would like the data to be pasted at the end of the previous copied data. Therefore the "complete" worksheet would end up with data from all 50 html files.
I hope I have been clear in my explanation and any help would be appreciated, many thanks, Alan.