linking multiple books (source.xls) to a single book (destination.

[Guest]

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.

 

[Ron de Bruin]

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

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.

 

[Guest]

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.

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

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.

 

[Ron de Bruin]

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
Insert>Module 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

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.

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

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.

 

[Guest]

thanks ron, ill give it a try. Appreciate the help.

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
Insert>Module 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

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.

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



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.