Import data from four columns to single column in new sheet
 

I have Four wookbooks for different customers and each book has a sheet with
key info on spend etc. I want to Extract from each of these sheets key data
and put onto a single sheet. So.. Can i take all the dat from column A of
each sheet and import it to colum A of a single sheet, in a new workbook
keeping it in individual rows?

Import data from four columns to single column in new sheet
 

Hi Kernow1962

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

with this example you can select the four workbooks
http://www.rondebruin.nl/copy3.htm#select


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Kernow1962" wrote in message ...
I have Four wookbooks for different customers and each book has a sheet with
key info on spend etc. I want to Extract from each of these sheets key data
and put onto a single sheet. So.. Can i take all the dat from column A of
each sheet and import it to colum A of a single sheet, in a new workbook
keeping it in individual rows?