• 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

    Hui...

  • 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

Status
Not open for further replies.

denis_b

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.

81114
 

vletm

Excel Ninja
denis_b
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.
 
Status
Not open for further replies.
Top