Hello Robb, bother yu again.......
Posted by -------------------Ian on September 24, 2001 7:19 PM
Thanks Robb, it works for the column A of sheet 2, how to make the column B to EZ auto-formulated itself too?
Sorry that i am not good at programming.
You really are a genius!
I think you'll need to use code in Sheet1. Try this, it should complete
the formulae down columnA
- Right click on the page tab for Sheet1
- Select View Code
- Paste this code in the code window
It will copy any formula from A1 in Sheet2 to A2 if you enter something
in Sheet1 A2 and so on down the column.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Application.Intersect(Target, .Columns(1)) Is Nothing Then
ad = Target.Address
If ad = "$A$1" Then GoTo skip
Worksheets("Sheet2").Range(ad).Offset(-1, 0).Copy Destination:=Worksheets("Sheet2").Range(ad)