Moving data across a row as each day passes

[UMAKEMESIK]

Hello,

is it possible to set up a sheet that on day 1 of a project I enter information.
on day 2 the information automatically moves to the same row but now is on Column B ( day2)

on Wednesday ( day 3), the data originally entered into column A on Monday is now in Column c ( day 3)

and so on.

As each time period elapses i would like the data to move to the next cell horizontally.

I say time period because i may want some projects to move to the next cell every 12 hours for fast moving projects.

or if its easier we can have it set so that each progressing calendar day the data moves to the next cell.

if the project has progressed to friday ( 5 days ) and 5 cells across , then the project is late.

any help would be appreciated.

Not sure if this is conditional formatting or VB

Have a nice weekend.

 

[mikerickson]

The easiest thing would be for you to select a cell or an entire column, right click and insert. This way you can do it every 12 hour when needed, skip the insert on holidays and weekends on those days it isn't needed.

 

[UMAKEMESIK]

Thanks for that and taking the time.

would it be possible to use something like this

[code}
'Move column C to column D
Sub MoveColumn()
Columns("C").Cut
Columns("E").Insert
End Sub
[/code}

but put a time element in the code so that if i enter something on 8/24
when i open the sheet on 8/25 the data will have moved from column c to column d.

and so on ?

we have six total columns

so i our situation it would be

Column C would be the first day we enter some data in the cell.


c-d
d-e
e-f
f-g
and then stop.

any insights would be appreciated.

 

[UMAKEMESIK]

'Move column C to column D
Sub MoveColumn()
Columns("C").Cut
Columns("E").Insert
End Sub