| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
update data from one workbook to another
How would I accomplish this without having both books open and copy/paste each time? Workbook 5, sheet 22, column 9 needs to have the data from Workbook 1, sheet 3, column 2, Workbook 5 needs to be able to pull the data from workbook 1 and update it to match when I open the workbook, it needs the entire column of data. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
update data from one workbook to another
Try this...
Do this one time...Do your normal copy operation BUT instead of pasting do Right clickPaste SpecialPaste Link. -- Biff Microsoft Excel MVP "dalmom" wrote in message ... How would I accomplish this without having both books open and copy/paste each time? Workbook 5, sheet 22, column 9 needs to have the data from Workbook 1, sheet 3, column 2, Workbook 5 needs to be able to pull the data from workbook 1 and update it to match when I open the workbook, it needs the entire column of data. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
update data from one workbook to another
Biff to my rescue again! Worked perfectly Copied entire column, Workbook 1, sheet 3, column 2 pasted link to entire column in Workbook 5, sheet 22, column 9 Simple, to the point, easy to understand! Thanks again Biff! "T. Valko" wrote: Try this... Do this one time...Do your normal copy operation BUT instead of pasting do Right clickPaste SpecialPaste Link. -- Biff Microsoft Excel MVP "dalmom" wrote in message ... How would I accomplish this without having both books open and copy/paste each time? Workbook 5, sheet 22, column 9 needs to have the data from Workbook 1, sheet 3, column 2, Workbook 5 needs to be able to pull the data from workbook 1 and update it to match when I open the workbook, it needs the entire column of data. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
update data from one workbook to another
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "dalmom" wrote in message ... Biff to my rescue again! Worked perfectly Copied entire column, Workbook 1, sheet 3, column 2 pasted link to entire column in Workbook 5, sheet 22, column 9 Simple, to the point, easy to understand! Thanks again Biff! "T. Valko" wrote: Try this... Do this one time...Do your normal copy operation BUT instead of pasting do Right clickPaste SpecialPaste Link. -- Biff Microsoft Excel MVP "dalmom" wrote in message ... How would I accomplish this without having both books open and copy/paste each time? Workbook 5, sheet 22, column 9 needs to have the data from Workbook 1, sheet 3, column 2, Workbook 5 needs to be able to pull the data from workbook 1 and update it to match when I open the workbook, it needs the entire column of data. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
update data from one workbook to another
Hi dalmom. I have just put up your 2 (EXCEL 2007) files at:-
www.pierrefondes.com These will do what you want them to do. When opening workbook5 you will need to:- - hit Options (towards top / middle of screen) - select Enable this content / OK This will then pull in the info from Workbook 1. Please hit Yes if my comments have helped you. (If you do not understand my instructions ask away and I will try and clarify). "dalmom" wrote: How would I accomplish this without having both books open and copy/paste each time? Workbook 5, sheet 22, column 9 needs to have the data from Workbook 1, sheet 3, column 2, Workbook 5 needs to be able to pull the data from workbook 1 and update it to match when I open the workbook, it needs the entire column of data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook will not update after pasting data | Excel Worksheet Functions | |||
| update workbook | Excel Worksheet Functions | |||
| Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
| Can one workbook/sheet update another workbook? | Excel Discussion (Misc queries) | |||
| how can update the data in an excel workbook without opening it | Excel Worksheet Functions | |||
Hybrid Mode
