If then statement Excell 2000

[Guest]

What would the proper sequence be to prform the following:
IF A2=A3, THEN copy C2 to C3, D2 to D3, E2 to E3, H2 to H3.

Is this possable? Thanks much

 

[Dave Peterson]

You have a reply to your post in .misc

What would the proper sequence be to prform the following:
IF A2=A3, THEN copy C2 to C3, D2 to D3, E2 to E3, H2 to H3.

Is this possable? Thanks much

 

[Guest]

I have a mcro that will do the same function, but now have this issue:
need this macro to automactically fill in down a colum, but to skip any
cells with data in it. After it skips the cell with data it will use that
cell for the new data until it hits and skips another cell with diferent data
and repeats using new data.
'
' Macro5 Macro
' Macro recorded 12/16/2005 by Fairview
'
' Keyboard Shortcut: Ctrl+a
'
ActiveCell.Offset(-1, 0).Range("A1").Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A2"), Type:= _
xlFillDefault
ActiveCell.Range("A1:A2").Select
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub

any ideas? thanks much