| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Linked Cells
Need help on how to copy linked cells into another file and keep the
links. I have several files which have links in them, need to combine all into one file so we can autofilter through all entries. When I copy over the data and paste, the link does not come with it. Tried paste all and still does not work. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Linked Cells
Try right-click on the sheet tab, then 'Move or Copy' then 'Move Selected
Sheets to Book' then 'Create a Copy' then 'OK'. Regards, Ryan-- -- RyGuy "Tom" wrote: Need help on how to copy linked cells into another file and keep the links. I have several files which have links in them, need to combine all into one file so we can autofilter through all entries. When I copy over the data and paste, the link does not come with it. Tried paste all and still does not work. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy linked worksheet | Excel Discussion (Misc queries) | |||
| Copy Formula with Linked Cells - Validation Question | Links and Linking in Excel | |||
| How do you copy and rename linked worksheets? | Excel Discussion (Misc queries) | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
Linear Mode
