saving data and moving to the next column
 

is there a way to save data that is entered into a sheet from a data base and
move to the next column each day new information is sent to the sheet. I want
to keep the information in the spicific column but save it then move to the
next colume for the next day automaticaly saving as i go.