Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from one column to another | Excel Discussion (Misc queries) | |||
saving data and moving to the next column | Excel Programming | |||
Freezing the data in a column and moving the calculations to the next column | Excel Programming | |||
moving data within a column | Excel Worksheet Functions | |||
Moving XL Data over By one Column (*Same Row) | Excel Programming |