Hi ya'll,
If I need to specify the source cell from book1 and cell A1--it's simple. But what if I need to preserve all the custom settings, formats, colors, borders, etc.?
If it's simply one-off job, it's easy: copy, paste special, all except borders.
Is there anything similar for linking/referencing?
many thanks
If I need to specify the source cell from book1 and cell A1--it's simple. But what if I need to preserve all the custom settings, formats, colors, borders, etc.?
If it's simply one-off job, it's easy: copy, paste special, all except borders.
Is there anything similar for linking/referencing?
many thanks