How can I make this timetable adjustable

[tuurevv]

Hi!

I am a bit new to programming and I have a very simple version and harsh code to make do the following.

How could I do this easier way and if I want to add or remove rows it doesn't mess up other rows later in the worksheet?

The idea of this is that Task 1 starts at 9:30 and ends at 10:30. If I want for example to change the end time of Task 1 or start time of Task 2 the timetable can now understand to change the time by the idea of Cell 1 = Cell 2 and Cell 2 = Cell 1.

Also it would be great to know if it is possible to make this work like this: If I want to make Task 1 to start for example 10:30, the whole timetable knows to change times 1 hour later (every start or finish time of the following tasks.

The code at the moment goes like this:

Please Login or Register  to view this content.

Hope you understand what I am explaining and trying to do!

[Olly]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.