Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
How can I replace the path of the linked spreadsheet in a cell? | Excel Worksheet Functions | |||
How do I move the current cell to the top of the screen? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |