Data Extraction from Excel

I need to extract certain bits of data from a spreadsheet and plce into a new spreadsheet. I was wondering what would be the easiet way.

The data is laid out like this in the current spreadsheet

Trader - Lots - ticks - profit

For my new spreadsheet I want to take the data from Trader, and the data from ticks and import that into a new spreadsheet.

Hi backoffice,
read this link about crossposting :http://www.excelguru.ca/node/7

Originally Posted by arthurbr

Hi backoffice,
read this link about crossposting :http://www.excelguru.ca/node/7

Hi Arthur - Sorry abou tthat, have talen note and will make it clearer on future threads.
many thnaks
alam