we have an issue where we get an excel report ( our PMO dept uses MS EXCEL) from which we have like products
product 1 start date end date
each product has a product life cycle which we are trying to put into MS project. I wanted to know a couple of things:
-note: the products and dates change and as such need to be reflected in MS project (that is why i needed to do manual linking)
1. is there an automatic/easier way to "link" all the start/end dates into ms project which at the moment is very cumbersome given the crazy amount of products we have (horribly manual error prone process)? via programming or maybe i can put the ms excel file into another file format which ms project can easily get somehow?
2. I am trying to have multiple products within one project plan. So, i defined the first product and its tasks/milestones with proper linking (both kinds linking with ms excel dates and linking internally of tasks like FS/FF etc). Now is it possible to just simply copy and paste the rest without losing any linking? apparently this is also a problem i am having.
I need serious help on this. I would really appreciate it since i am very new to ms project and trying to convince our company to use this instead of just all sorts of ms excel sheets.