Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Maintaining Cell Format in Query | Excel Discussion (Misc queries) | |||
Sorting multiple columns and maintaining grouping of information | Excel Discussion (Misc queries) | |||
Maintaining a formula in a cell when there was an insert row | Excel Discussion (Misc queries) | |||
Maintaining formula while clearing the cell | Excel Programming |