Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomCat
 
Posts: n/a
Default Replacing Linked Cell Values w/ Current Values

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Replacing Linked Cell Values w/ Current Values

Hi TomCat:

See:

http://support.microsoft.com/default...;en-us;q188449


--
Gary's Student


"TomCat" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomCat
 
Posts: n/a
Default Replacing Linked Cell Values w/ Current Values

Didn't work. It just stalled.

Are there any other ways of doing this?

"Gary''s Student" wrote:

Hi TomCat:

See:

http://support.microsoft.com/default...;en-us;q188449


--
Gary's Student


"TomCat" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Replacing Linked Cell Values w/ Current Values

Yes:


Look for FindLink in:

http://www.bmsltd.ie/MVP/Default.htm

--
Gary's Student


"TomCat" wrote:

Didn't work. It just stalled.

Are there any other ways of doing this?

"Gary''s Student" wrote:

Hi TomCat:

See:

http://support.microsoft.com/default...;en-us;q188449


--
Gary's Student


"TomCat" wrote:

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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomCat
 
Posts: n/a
Default Replacing Linked Cell Values w/ Current Values

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.

"Gary''s Student" wrote:

Yes:


Look for FindLink in:

http://www.bmsltd.ie/MVP/Default.htm

--
Gary's Student


"TomCat" wrote:

Didn't work. It just stalled.

Are there any other ways of doing this?

"Gary''s Student" wrote:

Hi TomCat:

See:

http://support.microsoft.com/default...;en-us;q188449


--
Gary's Student


"TomCat" wrote:

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



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
paul
 
Posts: n/a
Default Replacing Linked Cell Values w/ Current Values

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!



"TomCat" wrote:

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.

"Gary''s Student" wrote:

Yes:


Look for FindLink in:

http://www.bmsltd.ie/MVP/Default.htm

--
Gary's Student


"TomCat" wrote:

Didn't work. It just stalled.

Are there any other ways of doing this?

"Gary''s Student" wrote:

Hi TomCat:

See:

http://support.microsoft.com/default...;en-us;q188449


--
Gary's Student


"TomCat" wrote:

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

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomCat
 
Posts: n/a
Default Replacing Linked Cell Values w/ Current Values

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

TomCat

"paul" wrote:

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!



"TomCat" wrote:

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.

"Gary''s Student" wrote:

Yes:


Look for FindLink in:

http://www.bmsltd.ie/MVP/Default.htm

--
Gary's Student


"TomCat" wrote:

Didn't work. It just stalled.

Are there any other ways of doing this?

"Gary''s Student" wrote:

Hi TomCat:

See:

http://support.microsoft.com/default...;en-us;q188449


--
Gary's Student


"TomCat" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 23rd 05 11:04 PM
How can I break values apart that are in the same cell? Phil Excel Worksheet Functions 3 October 4th 05 03:41 PM
How can I replace the path of the linked spreadsheet in a cell? Norm Excel Worksheet Functions 2 July 30th 05 06:26 AM
How do I move the current cell to the top of the screen? mad.cow Excel Discussion (Misc queries) 6 May 29th 05 05:35 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"