| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
importing specific cells from multiple workbooks into 1 workbook
I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that
are in the same folder into 1 spreadsheet in a separate workbook.I want to insert a new row for the data from every workbook. All of the workbooks have the exact same format. Anyone know the easiest way to get this info compiled? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
importing specific cells from multiple workbooks into 1 workbook
Hi Water
Try the add-in or the code on this page http://www.rondebruin.nl/merge.htm http://www.rondebruin.nl/copy3.htm If you want to create formula links see http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Walter Davis" <Walter wrote in message ... I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that are in the same folder into 1 spreadsheet in a separate workbook.I want to insert a new row for the data from every workbook. All of the workbooks have the exact same format. Anyone know the easiest way to get this info compiled? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
importing specific cells from multiple workbooks into 1 workbo
Anyone ever tell you that YOU ARE THE MAN!? Thanks. You just saved a whole
days work... "Ron de Bruin" wrote: Hi Water Try the add-in or the code on this page http://www.rondebruin.nl/merge.htm http://www.rondebruin.nl/copy3.htm If you want to create formula links see http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Walter Davis" <Walter wrote in message ... I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that are in the same folder into 1 spreadsheet in a separate workbook.I want to insert a new row for the data from every workbook. All of the workbooks have the exact same format. Anyone know the easiest way to get this info compiled? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
importing specific cells from multiple workbooks into 1 workbo
Anyone ever tell you that YOU ARE THE MAN
I hope my wife will say this tonight <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Walter Davis" wrote in message ... Anyone ever tell you that YOU ARE THE MAN!? Thanks. You just saved a whole days work... "Ron de Bruin" wrote: Hi Water Try the add-in or the code on this page http://www.rondebruin.nl/merge.htm http://www.rondebruin.nl/copy3.htm If you want to create formula links see http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Walter Davis" <Walter wrote in message ... I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that are in the same folder into 1 spreadsheet in a separate workbook.I want to insert a new row for the data from every workbook. All of the workbooks have the exact same format. Anyone know the easiest way to get this info compiled? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
importing specific cells from multiple workbooks into 1 workbo
I just hope you're the guy in the room with her!!!!!!
<gd&r Ron de Bruin wrote: Anyone ever tell you that YOU ARE THE MAN I hope my wife will say this tonight <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Walter Davis" wrote in message ... Anyone ever tell you that YOU ARE THE MAN!? Thanks. You just saved a whole days work... "Ron de Bruin" wrote: Hi Water Try the add-in or the code on this page http://www.rondebruin.nl/merge.htm http://www.rondebruin.nl/copy3.htm If you want to create formula links see http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Walter Davis" <Walter wrote in message ... I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that are in the same folder into 1 spreadsheet in a separate workbook.I want to insert a new row for the data from every workbook. All of the workbooks have the exact same format. Anyone know the easiest way to get this info compiled? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
importing specific cells from multiple workbooks into 1 workbo
LOL
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... I just hope you're the guy in the room with her!!!!!! <gd&r Ron de Bruin wrote: Anyone ever tell you that YOU ARE THE MAN I hope my wife will say this tonight <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Walter Davis" wrote in message ... Anyone ever tell you that YOU ARE THE MAN!? Thanks. You just saved a whole days work... "Ron de Bruin" wrote: Hi Water Try the add-in or the code on this page http://www.rondebruin.nl/merge.htm http://www.rondebruin.nl/copy3.htm If you want to create formula links see http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Walter Davis" <Walter wrote in message ... I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that are in the same folder into 1 spreadsheet in a separate workbook.I want to insert a new row for the data from every workbook. All of the workbooks have the exact same format. Anyone know the easiest way to get this info compiled? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing specific data into an Excel workbook | Excel Worksheet Functions | |||
| Importing data into specific template cells | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Importing Workbooks into a Master Workbook | Excel Worksheet Functions | |||
Linear Mode
