Dear Excel Wizards,
Day to day I receive multiple newsfeed and I would like to collate all news that I find useful from a news provider or online publication and copy into a worksheet. It will be segregated by columns denoting the news title and the news itself? i.e. the code will copy the header of the news and paste into the designated column, subsequently copy the body of the news and paste into the designated columns by the next empty cell as it moves down the rows.
Is it possible that VBA can perform this function? I am stuck...help needed. Thank you much all.
Day to day I receive multiple newsfeed and I would like to collate all news that I find useful from a news provider or online publication and copy into a worksheet. It will be segregated by columns denoting the news title and the news itself? i.e. the code will copy the header of the news and paste into the designated column, subsequently copy the body of the news and paste into the designated columns by the next empty cell as it moves down the rows.
Is it possible that VBA can perform this function? I am stuck...help needed. Thank you much all.