Automatic update of a cell based on the value of a cell in another worksheet

[Hippolyte]

Hello,

I would like to know if there is a way to automatically update the content of a cell based on the value of a cell in another sheet ?

That original cell's value is based on a drop down menu.

Could someone exlpain to me how to make it work ?

Thank you very much for your help

 

[WarfritLive]

=Sheet 2!A1
That's to match it. Substitute the sheet and cell location

=IF(Sheet 2!A1="whatever text you're looking for", "what you want the result to be")

That's if you want the cell to say something different from the reference
Outside of that I'll need more specifics

 

[My Aswer Is This]

Yes that is possible

In you cell enter a formula like this:

=Sheet2!K5

In this example it looks to Sheet named "Sheet2" and get the value form Range("K5")

To make it easy just:

Click on the cell where you want the value entered and enter

= then click on the other sheet and the cell in the other sheet and then press enter.

 

[Hippolyte]

Hello,

Thank you for your input. Sorry, I haven't been very clear.

I'm looking for a way to automatically update the value from a cell (B) on a specific sheet based on the value from a cell (A) in another sheet.

This cell (A) offers data from a drop down menu and therefore, the cell (B) doesn't always update automatically when cell (A)'s value changes.

Can someone help me out on this one ?

Thank you very much in advance !

Best regards,
Hippolyte

 

[Anka]

I'm a newbie, but often use this
First, do a test in a new Workbook.
Paste this code in Sheet2 module.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim KeyCells As Range

    ' The variable KeyCells contains the cells that will
    ' cause an alert when they are changed.
    Set KeyCells1 = Range("$A$1")

    If Not Application.Intersect(KeyCells1, Range(Target.Address)) _
           Is Nothing Then
        Sheets("Sheet1").Range("B1").Value = Sheets("Sheet2").Range("A1")
    End If

End Sub

 

[My Aswer Is This]

Well two of us have shown you how to do this and your saying neither of our answers worked for You.

Lets assume your two sheets are named:

"One" and "Two"


In Sheet "One" Range ("A1")

Enter this formula

=Two!A1



It's that simple

"Two" is the sheet name and A1 is the sheet range

It does not matter if the value is entered as part of Drop down menu

Are you saying you have done what we have told you and it does not work or have you never tried this.

And if you really need help it would be good to check in here more often. It was nearly a month ago since your last chimed in here.