Cell Population
Your welcome
"Chiccada" wrote:
Thanks Mike, much appreciated.
Regards,
Rik
"Mike H" wrote:
Right click your sheet tab, view code and paste this in
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 3 Or Target.Cells.Count 1 Or _
IsEmpty(Target) Then Exit Sub
Select Case Target
Case 601, 609, 623, 631
Target.Offset(, -1) = "Fees"
End Select
End Sub
Mike
"Chiccada" wrote:
Hi all,
I am currently tring to create a Macro Which populates any cell in Column
B based on what is entered in the adjacent cell in Column C. For example, if
I enter any one of 601, 609, 623 or 631 in Column C, the cell next to it in
Column B returns the word "Fees". Any other number returns nothing.
Thanks in advance for your help.
Regards
|