When I copy (Data:Column - Rows) and paste right below prior data why do all my functions change.
How do I prevent this from happening.
Some functions I’m able to put “$” and it will keep the function (command) but I cannot do this for all functions (=sum( ))
How do I copy / paste without any data changing within the copied cells when I paste to a new row.
Purpose: trying to see overall data and sorted data in the same document.
thank you in advance for any help anyone provides.