I have seven columns, mon tue etc and 1 column called Balance. I need to type data in mon and the same data appear in column balance then I want to type data in tues and want it to over write the column balance with tue data. leaving the mon column intact. I want to do the same with the rest of the week
Sorry it has taken a while to get back to you - i've been away. I want to divide the week into two sections - the first being Mon,Tues, Wed and then a balance column. The balance will always be the last figure that was entered. The formula you gave does exactly what I want for this first section of the week.
Then I want to leave this as it is, but do the same thing for the second half of the week i.e. Thur, Fri, Sat, Sun and then balance.
Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim iRow, iCol iRow = Target.Row iCol = Target.Column If iCol >= 1 And iCol <= 3 Then Cells(iRow, 8) = Target.Value ElseIf iCol >= 4 And iCol <= 7 Then Cells(iRow, 9) = Target.Value End If End Sub
This thread is now locked and can not be replied to.