Move columns to the left every new day

[04herrs]

I have dates that will move to the left every day. There is data that pertains to those dates. How do I get the data to move with the dates?

thank you

 

[AliGW]

Erm ... Any chance of sharing the data layout with us?

 

[JLGWhiz]

I have dates that will move to the left every day. There is data that pertains to those dates. How do I get the data to move with the dates?

thank you

also, how are you moving the dates? Formula or VBA? Every little bit helps.

 

[04herrs]

In one cell I have =today() and then the other cells reference that (=startdate) and then a formula that pluses off of each day to get me out to a week ahead (=b8+1) (=d8+1) and so on. Does that make sense?

 

[JLGWhiz]

In one cell I have =today() and then the other cells reference that (=startdate) and then a formula that pluses off of each day to get me out to a week ahead (=b8+1) (=d8+1) and so on. Does that make sense?

I could spend hours guessing at where on your worksheet these items are located. But I won't do that. I will wait until you can describe where by column and row in Excel term like cell A1, B1, ect. that the data and formulas are located. When you can describe it so we can understand what your data looks like and how you currently manipulate it, then maybe we can offer some help.

 

[04herrs]

I could spend hours guessing at where on your worksheet these items are located. But I won't do that. I will wait until you can describe where by column and row in Excel term like cell A1, B1, ect. that the data and formulas are located. When you can describe it so we can understand what your data looks like and how you currently manipulate it, then maybe we can offer some help.

Sorry about the lack of information. The dates are in cells B&C8 (merged), D&E8(merged), F&G8(merged), H&I8(merged), J&K8(merged), L&M8(merged), and N&O8(merged). The contents from Cells B&C10-40 will correlate with the date in B&C8, and so on. So when the new date starts they will all shift over. I'm not the smartest with excel and I'm not sure what other information you will need but if you need more I will be more than willing to provide it.

Again Thank you!

 

[NoSparks]

Sub ShiftData()
    Dim a
With Sheets("Weekly Task Schedule")
    a = .Cells(10, 4).Resize(31, 14).Value
    .Cells(10, 2).Resize(31, 14) = a
End With
End Sub

The issue will be triggering this when the date changes.

You need to provide links to other forums.

 

[04herrs]

Sub ShiftData()
    Dim a
With Sheets("Weekly Task Schedule")
    a = .Cells(10, 4).Resize(31, 14).Value
    .Cells(10, 2).Resize(31, 14) = a
End With
End Sub

The issue will be triggering this when the date changes.

You need to provide links to other forums.

a link for the file?

 

[04herrs]

I'm open to other ideas. The goal is for people to open this up and only be able to see a week at a time. They would be able to sign up for open spots under certain dates and times. This has started out as a template that I've customized for my information.

https://www.dropbox.com/s/uohjhmi2a0tebc5/Drill Hall.xlsm?dl=0

 

[JLGWhiz]

I'm open to other ideas. The goal is for people to open this up and only be able to see a week at a time. They would be able to sign up for open spots under certain dates and times. This has started out as a template that I've customized for my information.

https://www.dropbox.com/s/uohjhmi2a0tebc5/Drill Hall.xlsm?dl=0

I believe NoSparks was referring to cross posting in other forums when referring to the links.