hi Tinbendr, thanks for your help, but your codes didn't do all the steps i mentioned. If all the steps were are done successfully, there should be over 500 of lines extracted into the spreadsheet but right now there is only 50 plus of lines
I have attached the workbook wit your codes. Do take a look.Thank you.
Attachment 4855