Dear Umesh,
I have re-formulated the attached workbook.I don't think a macro is required
in this revised scenario.
Please check and get back to me in case of any queries.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
Dear Umesh,
Try following macro - easy to understand as well.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
I = ActiveCell.Address
If I = "$G$31" Then
Range("H31").Formula = "=F31*10%"
Range("i31").Formula = "=H31*2%"
Range("j31").Formula = "=H31*1%"
ElseIf I = "$G$32" Then
MsgBox
