Maintaining Information in a Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gator - 20 Feb 2007 01:17 GMT

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?

Reply to this Message

dkinn - 20 Feb 2007 06:16 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> Any suggestions?

Reply to this Message