I have been trying to create a filing system for a lawfirm that I am currently interning at how I am struggling to create a way to copy the cell contents of a given cell and have it moved and "saved" so that when the original cell is changed the new one stays the same:
Here is what it should look like:
LastName: Duncan
FirstName: Charles
Telephone #: (910)-978-9886
Email:
Duncan Charles (910)-978-9886
(And when that dated is deleted it saves and when new data is entered it will go one row down).