Extract and Manipulate Data from Website

**Richard Buttrey** · 02-07-2010, 11:57 AM

Hello Barry and welcome to the forum.

Almost impossible to say without seeing the data. Does the site not allow you to download the data as a file, and if not can you not copy/paste it into an Excel workbook?

Rgds

**GU42gold** · 02-08-2010, 08:35 AM

Hi Richard,

I've attached the spreadsheet created by Extracting data from Web. The Copy n Paste workbook is too large to attach as it exceeds the 1Mb limit due to it including the pictures.

You'll see that the information is in one column, whereas I need it in multiple columns. Cut n Paste creates the same singular column of data.

SMAI do not have the data in any downloadable format of any type.

thanks
Barry

**Richard Buttrey** · 02-08-2010, 10:12 AM

Hi Barry,

The file you attached contains information across 3 columns so I'm not sure what you mean by information being in 1 column. Can you clarify?

Regards