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.

saving data and moving to the next column
 

the best way is to insert a column.
You can highlight the entire column and insert column.
if it is only certain rows, then highlight the cells (one column) you want
shifted to the right, then click right mouse button and insert.

This can be done with VBA code also.

Sub shiftright()

Set MyRange = Range("C3:C20")
MyRange.Insert shift:=xlToRight

End Sub


"ttlet" wrote:

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.