Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |