G
Guest
I would like to set up a production chart in Excel, what formulas do I enter?
The jobs could over run so this will alter the daily production sheets. I
want to be able to alter one job run and then it will rearrange the following
jobs. Can this be done and if so how do I do it? I am running mms office
excel 2003. I hope some one out there can solve my problem, I do hope its
possible too. I work for a printing company with no production sysytem at
all!! What I would like to do is to set up a daily, weekly and monthly
production sheet for jobs to be worked on. We have three departments, repro,
printing and finishing. I thought of colour coding each area, only so they
know what they are doing. I do know how to do formulas, i just not sue
whether this can be achieved in excel. I have designed balance sheet and
used hyperlinks before, this is a new one on me though. Any help will be
very gratefully appreciated.
Many thanks
Carole
The jobs could over run so this will alter the daily production sheets. I
want to be able to alter one job run and then it will rearrange the following
jobs. Can this be done and if so how do I do it? I am running mms office
excel 2003. I hope some one out there can solve my problem, I do hope its
possible too. I work for a printing company with no production sysytem at
all!! What I would like to do is to set up a daily, weekly and monthly
production sheet for jobs to be worked on. We have three departments, repro,
printing and finishing. I thought of colour coding each area, only so they
know what they are doing. I do know how to do formulas, i just not sue
whether this can be achieved in excel. I have designed balance sheet and
used hyperlinks before, this is a new one on me though. Any help will be
very gratefully appreciated.
Many thanks
Carole