Auto populate

[Dansp88]

Hi all, im a competant (but fairly basic) excel user, but need a littl
help here

I have attached a screenshot of the sheet i am dealing with...
Column F contains a drop down box containing the types of cal
recieved,and im trying to get it so that when 'hang up' is selecte
cells D*,E*,I*,J* (* used to replace row value as it will change) wil
auto popluate with the information shown and get G*, and H* to aut
populate with the current date and time respectively
but everything else needs to remain blank when any of the other option
are selected

I use a new sheet each month, some months this sheet can contain 20
rows, others 2000 depending on certain variables
Ideally i would like the cells that are to be populated to remain empt
(i think i could normally use an =IF formula?) as the sheet is used b
some fairly incompetant people so i dont want them throwing a panic i
they see a formula, or deleting it

oh, and it is seen by directors etc so needs to look good

I hope ive included all the information i need? please let me know i
you need anything else?

+-------------------------------------------------------------------
|Filename: Capture.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=408
+-------------------------------------------------------------------

 

[Don Guillett]

Hi all, im a competant (but fairly basic) excel user, but need a little
help here.

I have attached a screenshot of the sheet i am dealing with...
Column F contains a drop down box containing the types of call
recieved,and im trying to get it so that when 'hang up' is selected
cells D*,E*,I*,J* (* used to replace row value as it will change) will
auto popluate with the information shown and get G*, and H* to auto
populate with the current date and time respectively.
but everything else needs to remain blank when any of the other options
are selected.


I use a new sheet each month, some months this sheet can contain 200
rows, others 2000 depending on certain variables.
Ideally i would like the cells that are to be populated to remain empty
(i think i could normally use an =IF formula?) as the sheet is used by
some fairly incompetant people so i dont want them throwing a panic if
they see a formula, or deleting it.

oh, and it is seen by directors etc so needs to look good


I hope ive included all the information i need? please let me know if
you need anything else??


+-------------------------------------------------------------------+
|Filename: Capture.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=408|
+-------------------------------------------------------------------+

You can do this with a worksheet_change event macro in the sheet module of the same sheet. right click sheet tab>view code>insert this

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Row < 2 Or .Column <> 6 Then Exit Sub
If .Value = "Hung up" Then
..Offset(, 1) = Date
..Offset(, 2) = Time
End If
End With
End Sub