excel表格怎么自动清洗数据

1.excel如何实现自动清除数据?

用vba宏-vb编辑双击进入sheet3输入代码Private Sub Worksheet_Change(ByVal Target As Range)Dim iRow, iCol As IntegeriRow = Target.RowiCol = Target.Column If iCol =3 And Target <> "" Then Application.EnableEvents = False Cells(iRow, 2) = 0 Application.EnableEvents = True End IfEnd Sub这样子比如你所在c列只要输入，b列相应的行值为0~~~给分吧~~~~。