Greetings XL experts.

I have about 20 html tables with about 100 rows and 5 columns. I want to set
them up in Excel and apply simple formulas to do some processing. Only three
of the columns are useful and two of them could be combined.

The final result would be about 20 sets of two columns in Excel and a final
column that contains the summed data.

Can anyone suggest a process that would make this as simple as possible?

In case of intense curiousity ;-) this program would calculate my daily
nutrient intake. I have not been able to find a simple program to do this. I
found several but most were antiquated DOS or had mainly listings of very
processed foods which I avoid. The USDA has a very good web site that list
the nutrients in many foods but they didn't go that most useful step
further - to make it usable for 3 or more meals i.e a day's nutrient intake.
If anyone already has such a program, I'd be delighted.

TIA

rf

You can navigate through an HTML website programmatically using the Document
Object Model, OR, programmatically adjust the data after the import/copy has
occurred.

http://HelpExcel.com

"RedFox" wrote:

Greetings XL experts.

I have about 20 html tables with about 100 rows and 5 columns. I want to set
them up in Excel and apply simple formulas to do some processing. Only three
of the columns are useful and two of them could be combined.

The final result would be about 20 sets of two columns in Excel and a final
column that contains the summed data.

Can anyone suggest a process that would make this as simple as possible?

In case of intense curiousity ;-) this program would calculate my daily
nutrient intake. I have not been able to find a simple program to do this. I
found several but most were antiquated DOS or had mainly listings of very
processed foods which I avoid. The USDA has a very good web site that list
the nutrients in many foods but they didn't go that most useful step
further - to make it usable for 3 or more meals i.e a day's nutrient intake.
If anyone already has such a program, I'd be delighted.

TIA

rf

Thanks galimi.

I don't understand your answer but will check your link.

rf

"galimi" wrote in message
...
You can navigate through an HTML website programmatically using the
Document
Object Model, OR, programmatically adjust the data after the import/copy
has
occurred.

http://HelpExcel.com

"RedFox" wrote:

Greetings XL experts.

I have about 20 html tables with about 100 rows and 5 columns. I want to
set
them up in Excel and apply simple formulas to do some processing. Only
three
of the columns are useful and two of them could be combined.

The final result would be about 20 sets of two columns in Excel and a
final
column that contains the summed data.

Can anyone suggest a process that would make this as simple as possible?

In case of intense curiousity ;-) this program would calculate my
daily
nutrient intake. I have not been able to find a simple program to do
this. I
found several but most were antiquated DOS or had mainly listings of
very
processed foods which I avoid. The USDA has a very good web site that
list
the nutrients in many foods but they didn't go that most useful step
further - to make it usable for 3 or more meals i.e a day's nutrient
intake.
If anyone already has such a program, I'd be delighted.

TIA

rf