See Ron de Bruin's site for code.

http://www.rondebruin.nl/copy3.htm

Assumes all workbooks are in a single folder.


Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 02:24:01 -0800, Sandeep S. <Sandeep
wrote:

How do I collect data from many workbooks from select columns into a single
workbook automatically. I don't want to open each one manually and copy and
paste from it to the main workbook. The system should ask me for which file
to be opened.

Please can you help.

Thanks and regards,

Sandeep S.