Forum Discussion
move entire column
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
I get this message when I click on your link. I think you need to explicitly share it or grant permission to whoever has that link.
Reading your description, though, of how you maintain this--with the single sheet used for both Input and Output--I suspect a VBA routine, or Macro, might be capable of doing what you want. And that's outside of my expertise; I prefer to use a single database as the repository for all inputs and a separate sheet for outputs, with Excel functions doing the work required to go from raw data to useful report.
You basically are using Excel for its nice rows and columns, but not for its data manipulation (and calculation) capabilities, or at least that seems to be the case. So let's hope that a VBA expert checks in on this thread and takes a look at your sheet. I'll look when you give us access, but fear my skills may not be applicable.