Is there a way to use latest entered value in formula?

[Chartist]

I have prices from different vendors being entered in different columns. I need to select the last entered (updated) one for calculation. It can be from any column at random.

Currently I have to make the user copy paste that last entered value second time in another cell.

Surely there's a better way...? Thanks.

 

[mumps]

The only other option I can think of is to have a short macro that would do the copy/paste automatically upon data entry without the user having to do it. If that works for you, what is the cell where the last entered value would go?

 

[Chartist]

The only other option I can think of is to have a short macro that would do the copy/paste automatically upon data entry without the user having to do it. If that works for you, what is the cell where the last entered value would go?

I think that will work.

Input data is in A1, B1 or C1.

The last cell entered is required in D1. Thanks.

 

[mumps]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make an entry A1:C1 and press the RETURN key or TAB key.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("A1:C1")) Is Nothing Then Exit Sub
    Range("D1") = Target
End Sub

 

[Chartist]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make an entry A1:C1 and press the RETURN key or TAB key.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("A1:C1")) Is Nothing Then Exit Sub
    Range("D1") = Target
End Sub

this is awesome! thanks. i really need to learn VBA fully now

 

[mumps]

Glad it worked out.