I have a form that I need to create that will take information from the
previous months form and paste it into this months form in the correct
colum.... automatically.. or run a little routine..... I need it so the
user doesn't have to know how to manipulate excel too much.....

for example I have a sheet set up that has a total billed to customer in
colume H.

so the next month.. I need to create another form and have that colume of
numbers move into colume D(previous months column) on the next months form.
Then the current month information will go in and be added to the previous
month to get the total completed so far...... which is always colum H.

Does that make sense?

And so on and so on....


Any help would be appreciated.
Thanks