Moving data between to columns

[Tami]

I wrote a program detail inventory in a store broken down
by trype and area. I want to transfer the "current"
inventory to the "previous each time I do inventory in a
store. How can i do this with out cutting and pasting?