Hi,
I have a spreadsheet which I will be filling in over time using a HTML report provided by my company. The aim of the spreadsheet is to copy and paste the HTML table into excel and then work out a percentage of product rejections over time on another worksheet.
The main problems with the table I have are:- when pasting into excel sometimes the cells are merged from the HTML formatting - is there anyway to prevent this from happening and force unmerged cells, or could a macro be written to achieve this?
Between each row on the HTML table is a blank row for presentation purposes, I'm currently just hiding those rows, which is proving to be a pain, is there a way to automatically remove the blank rows when pasting into the excel worksheet, or remove blank rows based on a formula/macro/condition?
Many thanks for your help,
Paul
I have a spreadsheet which I will be filling in over time using a HTML report provided by my company. The aim of the spreadsheet is to copy and paste the HTML table into excel and then work out a percentage of product rejections over time on another worksheet.
The main problems with the table I have are:- when pasting into excel sometimes the cells are merged from the HTML formatting - is there anyway to prevent this from happening and force unmerged cells, or could a macro be written to achieve this?
Between each row on the HTML table is a blank row for presentation purposes, I'm currently just hiding those rows, which is proving to be a pain, is there a way to automatically remove the blank rows when pasting into the excel worksheet, or remove blank rows based on a formula/macro/condition?
Many thanks for your help,
Paul
