move entire column

gpinky74 

The problem I am having is I have set the dates to move from right to left on a daily basis on a rolling pattern, year in, year out. I would like to move the rest of the information in the sheet along with the dates instead of having to do it manually? Is this possible?

Thanks for giving the picture of the real application; much more helpful than a mockup. Although it does raise other questions. In particular, I'd like to know if this screen is also the place where data gets entered. Said another way it would appear that this screen is primarily an Output display--i.e., it's the report of current status on something or other; is it also the Input screen? Or is there another part of the workbook where data are entered, and then various Excel functions get used to create this display for that "raw data"? If it's the latter, if there's a database into which you enter data, and then use Excel to create this output, that would make it relatively easy to do what you're trying to do. If that's not the case, if this is both Input and Output, then, though it might be possible, it would be "more mechanical."

So which is it?

And, another important question: if the workbook here is not confidential or proprietary, would it be possible for you to post the actual workbook, rather than an image, and to do so on OneDrive or GoogleDrive, with a link here that grants edit access to that workbook? That would make it even easier for us to help you.