auto create data copy in another tab with no formulas? - Microsoft Community

need preserve  data:

have:

last name

first name

date

amount paid

use table

problem 1.

have column names [above]

when sort amount or date doesn't carry rest of row?

problem 2

would move data tab automatically

***post moved moderator appropriate forum category.***

Office / Unknown/other / Windows 8 / Office 2013