I have been using “Update values on another sheet” to do this for some time…, but as I have already a “Link & Load” setup for the same fields, I would like to see if I can use “Keep values synced with source” with a Dynamic Filter instead.
I have a Listing sheet that is populated via “link and load” after selecting the appropriate PROPERTY UNIT. However, when I make changes to the PORPERTY UNIT afterwards, I would like these changes to automatically be updated on the corresponding Listing (I.e. if the listing is currently listed “Y”). As I said, I am doing this now (presently disabled) using the “Update Values on another sheet” function. This function allows me to set the criteria such that only the Current Listings are updated.
So my question is, if I were to no longer use the “update value son another sheet function” an instead I select the “Keep loaded values synced with source” on the already present “Link and Load” on the Listing sheet, will a Dynamic filter suffice, so that only currently listed listing will be updated?
I looked up Dynamic filters on the Learning Centre as well as on this Forum, but this is not mentioned! Also I am quite apprehensive about trying to test this myself, as you may appreciate!
I look forward to your response!