| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maintaining position and Value of certain cells when inserting inf
Hi all
I'm running into a frustrating problem, I'm creating a timetable workschedule and preplan it month by month. For every month I assign a specific Job to each day so that every day has a specific job attached to it. Even though I try and stick to the schedule some jobs take longer than expected and I need to assign more days to them. I do this by simply inserting the job into an adjacent day and shifting everything over one day to the right. So far so good. The problem arises when I have jobs that can't be moved, so when I insert an extra day for a longer than expected job, I need the resultant rightward cell shift to skip these strict deadline jobs and shift past them like they don't exist. If anyone can help that would be great Thanks Mike -- MikeJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maintaining position and Value of certain cells when insertinginf
Hi
How do you decide when a job cannot shift and when it can? regards Paul On May 7, 11:16*am, MikeRZA wrote: Hi all I'm running into a frustrating problem, I'm creating a timetable workschedule and preplan it month by month. For every month I assign a specific Job to each day so that every day has a specific job attached to it. Even though I try and stick to the schedule some jobs take longer than expected and I need to assign more days to them. I do this by simply inserting the job into an adjacent day and shifting everything over one day to the right. So far so good. The problem arises when I have jobs that can't be moved, so when I insert an extra day for a longer than expected job, I need the resultant rightward cell shift to skip these strict deadline jobs and shift past them like they don't exist. If anyone can help that would be great Thanks Mike -- MikeJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a row and maintaining the size | Excel Discussion (Misc queries) | |||
| Maintaining a cells value once a target is achieved | Excel Worksheet Functions | |||
| Inserting Rows and Maintaining Correct Balances | Excel Discussion (Misc queries) | |||
| Maintaining cell references when inserting cells elsewhere | Excel Discussion (Misc queries) | |||
| Maintaining row position in a loop | Excel Programming | |||
Linear Mode
