software

I have several worksheets with cells that are linked to other worksheets and
to other workbooks. Those other sheets and workbooks are now obsolete and I
need to paste the current values of those linked cells with their current
values....i.e., search the worksheet line by line, find a linked cell, copy
and paste its current LINKED value into that cell (thus overwriting the
link...), then continue searching for the next linked cell and do the same
until the linked values of the cells in entire worksheet have been replaced
with their current linked values.

Is there a function to do this? Or, is a macro the only way? If macro,
then how do I write it?

Thanks..........TomCat

Hi TomCat:

See:

support.microsoft.com/default...;en-us;q188449--
Gary's Studentquot;TomCatquot; wrote:

gt; I have several worksheets with cells that are linked to other worksheets and
gt; to other workbooks. Those other sheets and workbooks are now obsolete and I
gt; need to paste the current values of those linked cells with their current
gt; values....i.e., search the worksheet line by line, find a linked cell, copy
gt; and paste its current LINKED value into that cell (thus overwriting the
gt; link...), then continue searching for the next linked cell and do the same
gt; until the linked values of the cells in entire worksheet have been replaced
gt; with their current linked values.
gt;
gt; Is there a function to do this? Or, is a macro the only way? If macro,
gt; then how do I write it?
gt;
gt; Thanks..........TomCat

Didn't work. It just stalled.

Are there any other ways of doing this?

quot;Gary''s Studentquot; wrote:

gt; Hi TomCat:
gt;
gt; See:
gt;
gt; support.microsoft.com/default...;en-us;q188449
gt;
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;TomCatquot; wrote:
gt;
gt; gt; I have several worksheets with cells that are linked to other worksheets and
gt; gt; to other workbooks. Those other sheets and workbooks are now obsolete and I
gt; gt; need to paste the current values of those linked cells with their current
gt; gt; values....i.e., search the worksheet line by line, find a linked cell, copy
gt; gt; and paste its current LINKED value into that cell (thus overwriting the
gt; gt; link...), then continue searching for the next linked cell and do the same
gt; gt; until the linked values of the cells in entire worksheet have been replaced
gt; gt; with their current linked values.
gt; gt;
gt; gt; Is there a function to do this? Or, is a macro the only way? If macro,
gt; gt; then how do I write it?
gt; gt;
gt; gt; Thanks..........TomCat

Yes:Look for FindLink in:

www.bmsltd.ie/MVP/Default.htm

--
Gary's Studentquot;TomCatquot; wrote:

gt; Didn't work. It just stalled.
gt;
gt; Are there any other ways of doing this?
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; Hi TomCat:
gt; gt;
gt; gt; See:
gt; gt;
gt; gt; support.microsoft.com/default...;en-us;q188449
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;TomCatquot; wrote:
gt; gt;
gt; gt; gt; I have several worksheets with cells that are linked to other worksheets and
gt; gt; gt; to other workbooks. Those other sheets and workbooks are now obsolete and I
gt; gt; gt; need to paste the current values of those linked cells with their current
gt; gt; gt; values....i.e., search the worksheet line by line, find a linked cell, copy
gt; gt; gt; and paste its current LINKED value into that cell (thus overwriting the
gt; gt; gt; link...), then continue searching for the next linked cell and do the same
gt; gt; gt; until the linked values of the cells in entire worksheet have been replaced
gt; gt; gt; with their current linked values.
gt; gt; gt;
gt; gt; gt; Is there a function to do this? Or, is a macro the only way? If macro,
gt; gt; gt; then how do I write it?
gt; gt; gt;
gt; gt; gt; Thanks..........TomCat

Nope. Struck out again. Didn't do what I wanted it to do. I need it to
search a line for a cell that has a link, copy that value, delete the link,
then paste that value back in the cell.

Isn't there a quick macro that can do that? I've tried Hlookups, Indexes,
everything and can't quite get there.

quot;Gary''s Studentquot; wrote:

gt; Yes:
gt;
gt;
gt; Look for FindLink in:
gt;
gt; www.bmsltd.ie/MVP/Default.htm
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;TomCatquot; wrote:
gt;
gt; gt; Didn't work. It just stalled.
gt; gt;
gt; gt; Are there any other ways of doing this?
gt; gt;
gt; gt; quot;Gary''s Studentquot; wrote:
gt; gt;
gt; gt; gt; Hi TomCat:
gt; gt; gt;
gt; gt; gt; See:
gt; gt; gt;
gt; gt; gt; support.microsoft.com/default...;en-us;q188449
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Gary's Student
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;TomCatquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have several worksheets with cells that are linked to other worksheets and
gt; gt; gt; gt; to other workbooks. Those other sheets and workbooks are now obsolete and I
gt; gt; gt; gt; need to paste the current values of those linked cells with their current
gt; gt; gt; gt; values....i.e., search the worksheet line by line, find a linked cell, copy
gt; gt; gt; gt; and paste its current LINKED value into that cell (thus overwriting the
gt; gt; gt; gt; link...), then continue searching for the next linked cell and do the same
gt; gt; gt; gt; until the linked values of the cells in entire worksheet have been replaced
gt; gt; gt; gt; with their current linked values.
gt; gt; gt; gt;
gt; gt; gt; gt; Is there a function to do this? Or, is a macro the only way? If macro,
gt; gt; gt; gt; then how do I write it?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks..........TomCat

edit/links/break links,leaves the value thats there if when you first open
the sheet and it asks you to update say no,then go to edit
menu/links/breaklinks.......
you could use find using a phrase or prt phrase from your old links to find
them
--
paul

remove nospam for email addy!
quot;TomCatquot; wrote:

gt; Nope. Struck out again. Didn't do what I wanted it to do. I need it to
gt; search a line for a cell that has a link, copy that value, delete the link,
gt; then paste that value back in the cell.
gt;
gt; Isn't there a quick macro that can do that? I've tried Hlookups, Indexes,
gt; everything and can't quite get there.
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; Yes:
gt; gt;
gt; gt;
gt; gt; Look for FindLink in:
gt; gt;
gt; gt; www.bmsltd.ie/MVP/Default.htm
gt; gt;
gt; gt; --
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;TomCatquot; wrote:
gt; gt;
gt; gt; gt; Didn't work. It just stalled.
gt; gt; gt;
gt; gt; gt; Are there any other ways of doing this?
gt; gt; gt;
gt; gt; gt; quot;Gary''s Studentquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi TomCat:
gt; gt; gt; gt;
gt; gt; gt; gt; See:
gt; gt; gt; gt;
gt; gt; gt; gt; support.microsoft.com/default...;en-us;q188449
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Gary's Student
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;TomCatquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have several worksheets with cells that are linked to other worksheets and
gt; gt; gt; gt; gt; to other workbooks. Those other sheets and workbooks are now obsolete and I
gt; gt; gt; gt; gt; need to paste the current values of those linked cells with their current
gt; gt; gt; gt; gt; values....i.e., search the worksheet line by line, find a linked cell, copy
gt; gt; gt; gt; gt; and paste its current LINKED value into that cell (thus overwriting the
gt; gt; gt; gt; gt; link...), then continue searching for the next linked cell and do the same
gt; gt; gt; gt; gt; until the linked values of the cells in entire worksheet have been replaced
gt; gt; gt; gt; gt; with their current linked values.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Is there a function to do this? Or, is a macro the only way? If macro,
gt; gt; gt; gt; gt; then how do I write it?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks..........TomCat

Got it.......THANK YOU!!!!!

TomCat

quot;paulquot; wrote:

gt; edit/links/break links,leaves the value thats there if when you first open
gt; the sheet and it asks you to update say no,then go to edit
gt; menu/links/breaklinks.......
gt; you could use find using a phrase or prt phrase from your old links to find
gt; them
gt; --
gt; paul
gt;
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;TomCatquot; wrote:
gt;
gt; gt; Nope. Struck out again. Didn't do what I wanted it to do. I need it to
gt; gt; search a line for a cell that has a link, copy that value, delete the link,
gt; gt; then paste that value back in the cell.
gt; gt;
gt; gt; Isn't there a quick macro that can do that? I've tried Hlookups, Indexes,
gt; gt; everything and can't quite get there.
gt; gt;
gt; gt; quot;Gary''s Studentquot; wrote:
gt; gt;
gt; gt; gt; Yes:
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Look for FindLink in:
gt; gt; gt;
gt; gt; gt; www.bmsltd.ie/MVP/Default.htm
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Gary's Student
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;TomCatquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Didn't work. It just stalled.
gt; gt; gt; gt;
gt; gt; gt; gt; Are there any other ways of doing this?
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Gary''s Studentquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hi TomCat:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; See:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; support.microsoft.com/default...;en-us;q188449
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Gary's Student
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;TomCatquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I have several worksheets with cells that are linked to other worksheets and
gt; gt; gt; gt; gt; gt; to other workbooks. Those other sheets and workbooks are now obsolete and I
gt; gt; gt; gt; gt; gt; need to paste the current values of those linked cells with their current
gt; gt; gt; gt; gt; gt; values....i.e., search the worksheet line by line, find a linked cell, copy
gt; gt; gt; gt; gt; gt; and paste its current LINKED value into that cell (thus overwriting the
gt; gt; gt; gt; gt; gt; link...), then continue searching for the next linked cell and do the same
gt; gt; gt; gt; gt; gt; until the linked values of the cells in entire worksheet have been replaced
gt; gt; gt; gt; gt; gt; with their current linked values.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Is there a function to do this? Or, is a macro the only way? If macro,
gt; gt; gt; gt; gt; gt; then how do I write it?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thanks..........TomCat