I need to automatically copy the name and date from "Client" sheet to "Call" sheet based on a criteria or trigger which is "X" on a recurring basis.
Ex: If I put "X" on a cell, it will copy the data inside the "NAME" column for that particular row and the date on TOP (ABOVE CELL) of the "X" tigger.
I have attached a sheet
For the sake of example: If you look at "call" tab. It should copy "James Harry" and "December 6".