where do i have to paste the code? in which menu should i go?


Ο χÏ�ήστης "Stefi" Î*γγÏ�αψε:

A Worksheet_Change event macro like this may help:
Private Sub Worksheet_Change(ByVal Target As Range)
Range("E" & Target.Row).FormulaR1C1 = Range("E" & Target.Row -
1).FormulaR1C1
End Sub

It takes the formula from the previous row.
Change "E" to column letter needed!


Regards,
Stefi

€žangie€� ezt Ã*rta:

i have pasted a fomula in an entire column. the problem is that excel has
become very slow on open and save and i only have 100 records in total. is
there a way not to copy the formula in the entire column but each time a user
enters data in a row the corresponding cell in that row gets the fomula?

your help would be greatly appreciated!