Is there a way to copy web site data to excel to make it sortable
 

I am trying to copy data from a web site and paste it into excel. this I can
do however, excel does not recognize the data. Is there a way to make excel
recognize the data so that is can be sorted. totalled etc.

What you want is not difficult, just laborous. Lots of junk gets pasted when
the web content is pasted. Usually I have to erase the pictures & hyperlinks
with:

Selection.Hyperlinks.Delete
ActiveSheet.Pictures.Delete

in a macro and then unmerge cells and move things around.
--
Gary's Student


"Jetson2k" wrote:

I am trying to copy data from a web site and paste it into excel. this I can
do however, excel does not recognize the data. Is there a way to make excel
recognize the data so that is can be sorted. totalled etc.