multi formulae data entry

[ribit]

Hi,

I have an example to explain a bit more cleary what I want to do. Th
equation I use in my real problem is a much more complex equatio
(equations getting results from other 'equations' etc...) but it sho
briefly what i am trying to do...

Can anyone help?

thanks

Ma

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=58006

 

[Frank Kabel]

Hi Mat
of course you could use a macro which loops through your range in
column A/B but just as a question: Wyh not use formulas directly for
this? Performance issues?

For a macro try something like the following:
Sub calculate_values()
Dim row_index
Dim x_rng As Range
Dim y_rng As Range
application.screenupdating=false
With ActiveSheet
Set x_rng = .Range("F2")
Set y_rng = .Range("G2")

For row_index = 2 To 19
x_rng = .Cells(row_index, 1).Value
y_rng = .Cells(row_index, 2).Value
.Cells(row_index, 3).Value = .Range("G4").Value
.Cells(row_index, 4).Value = .Range("G5").Value
Next
End With
application.screenupdating=True
End Sub