LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a row and maintaining the size Karsea Excel Discussion (Misc queries) 2 March 13th 09 12:41 PM
Maintaining a cells value once a target is achieved cliff18 Excel Worksheet Functions 9 January 10th 09 04:11 AM
Inserting Rows and Maintaining Correct Balances Floridaguy Excel Discussion (Misc queries) 5 November 1st 07 01:25 PM
Maintaining cell references when inserting cells elsewhere Stephen Jefferson Excel Discussion (Misc queries) 3 August 5th 05 09:30 PM
Maintaining row position in a loop Tom Excel Programming 2 July 9th 03 03:59 PM


All times are GMT +1. The time now is 01:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"