RossTrepleton
New Member
- Joined
- Jan 22, 2010
- Messages
- 8
Hi All,
I have a problem with a production planning spreadsheet I use.
Heres the format:
Column A: order of work (1 to 10). This column has a sort macro on it so tasks can be re-arranged in order of importance.
Column B: Task (text)
Column C: Length of takes (hrs, from a look up of task vs time)
Column D :Task start time (formula is previous task end time, ie for row 3 it is E2 +1)
Column E: Task Finish time (C3+D3)
All this works fine until a somebody over writes one of the equation with a time, (ie task start time for row 3 becomes 48 instead of E2 + 1), and then the sheet is re-sorted.
using the re-sort (to make this task 2) the start time will remain at 48, rtaher than being reset to E1+1.
Is there a way within a macro to reset the resorted cells to their original equations, rather than resorting the over-written information?
I have a problem with a production planning spreadsheet I use.
Heres the format:
Column A: order of work (1 to 10). This column has a sort macro on it so tasks can be re-arranged in order of importance.
Column B: Task (text)
Column C: Length of takes (hrs, from a look up of task vs time)
Column D :Task start time (formula is previous task end time, ie for row 3 it is E2 +1)
Column E: Task Finish time (C3+D3)
All this works fine until a somebody over writes one of the equation with a time, (ie task start time for row 3 becomes 48 instead of E2 + 1), and then the sheet is re-sorted.
using the re-sort (to make this task 2) the start time will remain at 48, rtaher than being reset to E1+1.
Is there a way within a macro to reset the resorted cells to their original equations, rather than resorting the over-written information?
