Single calculation

[Juan C]

Help me here...
Is there a way for me to have a formula perform its calculation one time only... meaning that if the precedent data changes it (the formula) won't compute again, thus leaving the previous number it calculated unchange...

 

[Juan C]

And one last question, if I want also to capture the data from A2 and fill column C at the same time as we are doing with column B, is it possible?

Thanks

JC

OK... great!!! Now it's working. Many many thanks....

JC

 

[VoG]

Try

Private Sub Worksheet_Calculate()
If Cells(Rows.Count, "B").End(xlUp).Value <> Range("A1").Value Then
    Cells(Rows.Count, "B").End(xlUp).Offset(1, 0).Value = Range("A1").Value
End If
If Cells(Rows.Count, "C").End(xlUp).Value <> Range("A2").Value Then
    Cells(Rows.Count, "C").End(xlUp).Offset(1, 0).Value = Range("A2").Value
End If
End Sub

 

[Juan C]

Once again 10000000000000000 thanks

JC

Try

Private Sub Worksheet_Calculate()
If Cells(Rows.Count, "B").End(xlUp).Value <> Range("A1").Value Then
    Cells(Rows.Count, "B").End(xlUp).Offset(1, 0).Value = Range("A1").Value
End If
If Cells(Rows.Count, "C").End(xlUp).Value <> Range("A2").Value Then
    Cells(Rows.Count, "C").End(xlUp).Offset(1, 0).Value = Range("A2").Value
End If
End Sub

 

[Juan C]

Hi VoG.... here I go again...

Everything is working as expected..... but the data from A1 is coming faster than that from A2. Remember A1 is filling column B and A2 is filling column C. Now, is there a way to retrieve the data from A1 only when data from A2 changes, are still filling the same columns b and c with the results???

Thanks

JC

Once again 10000000000000000 thanks

JC

 

[VoG]

Try

Private Sub Worksheet_Calculate()
If Cells(Rows.Count, "C").End(xlUp).Value <> Range("A2").Value Then
    Cells(Rows.Count, "B").End(xlUp).Offset(1, 0).Value = Range("A1").Value
    Cells(Rows.Count, "C").End(xlUp).Offset(1, 0).Value = Range("A2").Value
End If
End Sub

 

[Juan C]

Great.... it works!!! Thanks again!!!!

Try

Private Sub Worksheet_Calculate()
If Cells(Rows.Count, "C").End(xlUp).Value <> Range("A2").Value Then
    Cells(Rows.Count, "B").End(xlUp).Offset(1, 0).Value = Range("A1").Value
    Cells(Rows.Count, "C").End(xlUp).Offset(1, 0).Value = Range("A2").Value
End If
End Sub

 

[Juan C]

Hello VoG... me again.

Is there a way to have a sheet perform its calculations based on agiven parameter? I said this because my whole work sheet is becoming pretty slow and I need to activate and deactivate certain sheets in order for the whole work to be faster.

It could be an If formula let say in C3 that says that if x parameter is OK, then the formulas in that sheet will execute, otherwise they won't...

Any ideas on how to do this besides indicating such formula in every single cell?

Thanks

JC

Great.... it works!!! Thanks again!!!!

 

[Juan C]

It could be that if C3=1, then the formulas in that sheet won't execute....

Hello VoG... me again.

Is there a way to have a sheet perform its calculations based on agiven parameter? I said this because my whole work sheet is becoming pretty slow and I need to activate and deactivate certain sheets in order for the whole work to be faster.

It could be an If formula let say in C3 that says that if x parameter is OK, then the formulas in that sheet will execute, otherwise they won't...

Any ideas on how to do this besides indicating such formula in every single cell?

Thanks

JC

 

[VoG]

Is this on the same sheet that you are capturing the values of the feed?

 

[Juan C]

Yes... the problem is that all that data have to be sorted and it's taking to much time for one sheet just to do that. So I thougt dividend each hour (3600 seconds = 3600 inputs) into sheets so each one do the sorting while the other ones are idling, thus increasing my response time. For example, I could say on C3 that if the present hour is >= than 14:00:00, then 1. If I get this response on this cell then some macro to instruct the formulas in that sheet tp proceed, itherwise they will be idling...

Is this possible??

Thanks

JC

Is this on the same sheet that you are capturing the values of the feed?