| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Daily data to weekly data conversion in Excel? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
| copying data from Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Linear Mode
