Forum Discussion
move entire column
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.
Once again, thank you for your help, I really appreciate it. This sheet is a lookahead program for a Hospital Project I am currently working on and is used to keep track of the amount of labour required to do specific tasks on and by specific dates/deadlines. All data is manually entered on this page and as of yet the only formulas set are to change the date when a new date is entered into cell Z4. I would like to use the =TODAY() formula, (if possible), in this cell so the date updates automatically on a daily basis in rows 8 and 9 respectively. The only problem I now see with this is the "day" row, row 10, would need to move also to correspond with the above dates.....! Say then if I was to leave the date cell, Z4, as manually entered data, say once a week on a Monday, would it be possible to make the rest of the data in the TASK rows below move along with the dates?
ANY help would be great help. Getting this sheet to perform the way i want would help me greatly. I have added a link below to an example of the sheet, thanks.
https://onedrive.live.com/edit.aspx?resid=D7B9FA12567331F4!173353&cid=d7b9fa12567331f4&CT=1687544790893&OR=ItemsView
