| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell auto population - why 0 when source cell is empty? | Excel Discussion (Misc queries) | |||
| Automatic Cell Population | Excel Programming | |||
| Automatic cell population | Excel Discussion (Misc queries) | |||
| Automatic Cell population | Excel Programming | |||
| hyperlink - cell population | Excel Programming | |||
Threaded Mode
