| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
