Is it possible to freeze or break a link automatically?

cdo1ca

New Member
Joined
Nov 14, 2005
Messages
2
Is it possible to freeze of break a link automatically after the value has been entered into the target cell? I would like to link a cell that changes daily to a row in another worksheet that will represent the full month, so each day in the monthly sheet I would like that days linked value to be saved so that it will not change the next day when I change the daily source cell.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,459
Welcome

1. Press Alt-F11 to bring up VBA
2. In the left pane, double-click the sheet to attch this to
3. Paste this into the right pane:

Private Sub Worksheet_Change(ByVal Target As Range)
if target.column = 1 then target.formula = target.value
End Sub

This assumes you want this to happen to anything in column A.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,388
Members
412,590
Latest member
Velly
Top