• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Connecting Dynamic Table with Manual Static Data in Sheets

Not open for further replies.


New Member
Hi I posted this problem last week but didn't get an answer, will try again and describe it better:

Gym churn report. Client details are imported from a CRM who match criteria (not attended a class for 30 days).
The Trainers then manually add if they contacted said member and add notes.
When this list is refreshed and client data gets shifted or removed, how can you link the Dynamic data with the Static Data.

Eg. Client moves up one row, Contacted/Notes also moves with the record.
Eg. Client is removed from the list and the Contacted/Notes are erased.



Excel Ninja
You should add these and more details to Your previous thread
instead to open a new thread.
Please reread Forum Rules - especially How to get the Best Results at Chandoo.org
This thread is closed.
Not open for further replies.