*Dumb newbie* How to automatically import data from 1 workbork to another
We have two workbooks maintained seperately.
Workbook 1 has a cell that has a total of a column that needs to be inserted in workbook 2 daily. My present procedure is to: Open book 1, look at that total, write it down. Open book 2, enter that total into appropriate cell in book 2. Is there any way to automate this? Something like: Just by opening book 1, it imports the data from that cell in book 2? Sorry for the really newbie question. I hope I asked correctly. |
*Dumb newbie* How to automatically import data from 1 workbork to another
Just enter the reference to the cell in book2 as follows:
='Filepath\[Filename]Sheetname'Cell EG: ='C:\[Book1.xls]Sheet1'!A1 Hth Jon "Hosh" wrote in message ... We have two workbooks maintained seperately. Workbook 1 has a cell that has a total of a column that needs to be inserted in workbook 2 daily. My present procedure is to: Open book 1, look at that total, write it down. Open book 2, enter that total into appropriate cell in book 2. Is there any way to automate this? Something like: Just by opening book 1, it imports the data from that cell in book 2? Sorry for the really newbie question. I hope I asked correctly. |
*Dumb newbie* How to automatically import data from 1 workbork to
Go to workbook 1 and copy the cell that you want.
Go to workbook 2 and select the cell you want the data copied to and then click Edit - paste special - paste link. Now whenever you open workbook 2 it will update automatically from workbook 1. Mike "Hosh" wrote: We have two workbooks maintained seperately. Workbook 1 has a cell that has a total of a column that needs to be inserted in workbook 2 daily. My present procedure is to: Open book 1, look at that total, write it down. Open book 2, enter that total into appropriate cell in book 2. Is there any way to automate this? Something like: Just by opening book 1, it imports the data from that cell in book 2? Sorry for the really newbie question. I hope I asked correctly. |
*Dumb newbie* How to automatically import data from 1 workbork to
Thanks!
That works great. 1 question though. Is there any way to eliminate the dialog box that asks if you WANT to update from the links? It would just be a little bit better if it just did that automatically. "Mike H" wrote in message ... Go to workbook 1 and copy the cell that you want. Go to workbook 2 and select the cell you want the data copied to and then click Edit - paste special - paste link. Now whenever you open workbook 2 it will update automatically from workbook 1. Mike "Hosh" wrote: We have two workbooks maintained seperately. Workbook 1 has a cell that has a total of a column that needs to be inserted in workbook 2 daily. My present procedure is to: Open book 1, look at that total, write it down. Open book 2, enter that total into appropriate cell in book 2. Is there any way to automate this? Something like: Just by opening book 1, it imports the data from that cell in book 2? Sorry for the really newbie question. I hope I asked correctly. |
All times are GMT +1. The time now is 07:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com