Copy Linked Cells

T

Tom

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?
 
R

ryguy7272

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Links to Another File 2
Excel Linking (I think) 17
Replacing Linked Cell Values w/ Current Values 6
How can I stop format change when copying data into unlocked cells 1
change multiple links at once 1
Slow file with INDIRECT.EXT 1
Copy Transpose and Link Data 1
Can I keep linked cells between sheets when using tables? 2

Top