| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking multiple books (source.xls) to a single book (destinat
thanks ron, ill give it a try. Appreciate the help.
"Ron de Bruin" wrote: Hi mday That is pretty heavy duty. Is there a simpler version of example 1. That seems to be what I am looking for but w/o all the bells and whistles. No Open a new workbook Alt -F11 InsertModule from the menu bar Paste the sub Change the sheet name and range in the macro Alt-Q to go back to Excel If you do Alt-F8 you get a list of your macro's Select "Summary_cells_from_Different_Workbooks_1" and press Run -- Regards Ron de Bruin http://www.rondebruin.nl "mday" wrote in message ... That is pretty heavy duty. Is there a simpler version of example 1. That seems to be what I am looking for but w/o all the bells and whistles. "Ron de Bruin" wrote: Hi mday Is there a way to make the name of the book a cell so i can just type in the name of the book (in that cell), so it will pull from the I am doing and it pulls from there. No But you can use this create a worksheet with links http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "mday" wrote in message ... I build 10 versions of the same book daily. I need to take the info that those books spit out and put them into a single book (destination.xls). As of now i am copy/pasting the info into the destination book and it is taking quite a bit of time. I figured out how to link to a single source and pull it in. (='C:\Documents and Settings\My Documents\[source.xls]Sheet1'!A1) Is there a way to make the name of the book a cell so i can just type in the name of the book (in that cell), so it will pull from the I am doing and it pulls from there. ie ='C:\Documents and Settings\My Documents\[J1]Sheet1'!A1 then in cell J1 would be the name of the book. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Build a single order sheet from a multiple page material list. | Excel Discussion (Misc queries) | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| update multiple worksheet in single book | Excel Worksheet Functions | |||
| Viewing multiple books | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Threaded Mode
