Forum Discussion
move entire column
Hi there,
I'm a bit of a novice at Excel and was looking for some advice. I have the cell H1 with the formula =TODAY() and cell B3 with =H1 and the rest of the cells on row B with =B3+1,=C3+1 and so on. On a daily basis when cell H1 updates automatically then in turn all the others do the same. What I want to do is move all the rest of the cells in the corresponding column (the coloured ones), with the date shown in the row above as it moves to left? How do I do this?
I have added a screenshot for you, thanks in advance.
5 Replies
What I want to do is move all the rest of the cells in the corresponding column (the coloured ones), with the date shown in the row above as it moves to left? How do I do this?
I'm sure there are ways to accomplish this, although your request raises questions in my mind that need to be answered first.
- What is the new color for B6 (i.e., the cell(s) associated with whatever date is in cell B3, which is today's new date? And then again the next day. And the next.....
- There are eleven days there now; will you just be dealing with a rotating set of eleven days, or does each new day extend the number of dates in row 3 and the colored cells below?
But the most important set of questions: What is this all about in the first place? What do the colors designate? Why? What are you seeking to accomplish with this spreadsheet?
You see you've had over 50 views of your request and no replies until this one; I suspect that's because of the ambiguity of what this is all about; the suspicion that there probably is a better way to accomplish whatever it is that you're trying to accomplish. The mechanical task of moving the colors can be handled, but why pour energy into that if the real tasks can be accomplished in a different manner altogether?!
Hello and thank you for your reply,
The screenshot I shared is something basic put together to emulate a spreadsheet which is use at work, please see below picture for reference. 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?
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.
