How to refer to another sheet

[Romano_odK]

Good afternoon,

I got this code and it works great, but can I let it look into another sheet. So this line works in my sheet called "Orders" with the table name "Orderregels", but what I now need to have it from a sheet called "Data" and table called "Datatable". The command button is on the sheet "Orders" and I need to get the information from sheet "Data" with table name "Datatable".

Can this be done?

Thank you for your time.

Fiatteren.Caption = "geen fiat" & Chr(10) & Application.CountIf(Range("Datasheet[Fiat]"), "=N")

 

[RoryA]

Your code doesn't refer to a table called Orderregels anywhere.

Which column in the Datatable table do you need it to look at?

 

[Romano_odK]

Your code doesn't refer to a table called Orderregels anywhere.

Which column in the Datatable table do you need it to loo

That column is called "Fiat".
Yes I changed the name a few moments ago, indeed its not in this code.

 

[RoryA]

You need to refer to Sheets("Data").Range("Datatable[Fiat]")

 

[Romano_odK]

You need to refer to Sheets("Data").Range("Datatable[Fiat]")

Thank you that's what I needed. Have a nice day.

 

[Romano_odK]

Ok its does not work, any suggestions? This is what I got and I placed it in "ThisWorkBook".

Private Sub worksheet_change(ByVal target As Range)

Fiatteren.Caption = "geen fiat" & Chr(10) & Application.CountIf(Sheets("Data").Range("Datatable[fiat]"), "=J")

End Sub

 

[RoryA]

You can't put a worksheet_change event in the ThisWorkbook module. It won't do anything. It should be in the code module of the sheet where you want to monitor changes - though you would normally limit it to monitoring a particular range.