|
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? |
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? |
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? |
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? |
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 |
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 |
| All times are GMT +1. The time now is 04:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com