JohnMurphy
New Member
- Joined
- Jul 28, 2010
- Messages
- 8
I’m trying to develop a macro for a spreadsheet I’m working on. What I’m trying to do is have a group of cells shift left or right according to the date that is entered to the far left.
For example, if 01/01/10 is entered, the macro would shift the cell group of that row so they begin at the january column. The cell in the group should all remain adjacent to one another.
Please let me know if there is anything else you need for help, such as a screenshot or an upload. I am also looking to see if excel can optimize the position of the cell group on its own, to minimize monthly costs, but I can put that in a separate thread, if need be.
Thank you.
For example, if 01/01/10 is entered, the macro would shift the cell group of that row so they begin at the january column. The cell in the group should all remain adjacent to one another.
Please let me know if there is anything else you need for help, such as a screenshot or an upload. I am also looking to see if excel can optimize the position of the cell group on its own, to minimize monthly costs, but I can put that in a separate thread, if need be.
Thank you.