Maintaining Information in a Cell
 

I need to have the information that I input into one cell (cell A) link to a
different cell (cell B) and stay permanent into (cell B). Then the
information I put into cell A the next day link to cell C and stay permanent
in cell C. Cell A is alway a working cell and Cell B, C, D, & E and so on
will stay permanent.

Any suggestions?

Maintaining Information in a Cell
 

the quick and dirty way, (that is without a lot of error checking would be
something like)

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 1 Then
ColCnt = Application.WorksheetFunction.CountA(Range(Target. Row & ":" &
Target.Row))
Target.Offset(0, ColCnt).Value = Target.Value
End If

End Sub

Put into the worksheet_Change event
Any time a value in column "A" is changed it copies the value to the next
column.
First to B then C then on and on

It's a start.

David

"Gator" wrote:

I need to have the information that I input into one cell (cell A) link to a
different cell (cell B) and stay permanent into (cell B). Then the
information I put into cell A the next day link to cell C and stay permanent
in cell C. Cell A is alway a working cell and Cell B, C, D, & E and so on
will stay permanent.

Any suggestions?