Hi all
Im creating a Master Iinformation Release Schedule in excel. The dates are subject to change so rather than having to change them every time in the excel document, is there any way of linking the dates in the excel document to the dates in the Powerproject file, so that each time the PP dates are changed the MIRS is updated automatically please?
Hi Christine,
I would normally do this by using tabular reports. A report is created in the same format as the report you want. One click is then all that is need to update the report each time. If you want more information or help on this please let me know.
Regards
Andrew
Hi Mike
ah well - copy & paste it is
thanks for the reply :)
Hi Christine
I do not know of any link available between cells in the Powerproject spreadsheet and Excell.
You can however copy / paste from any Power Project column into Excell columns.
The problem is that the time values come with it so you have convert it to date numbers.
If you want your date in say Column C then paste the dates into column E
In Column D type =left(d#,10) and that will lift out the pure date data
In column C type =value(d#) and then format it to the date type you want.
Whenever you copy paste date columns back into excell Col E the dates will format correctly.
Make absolutely sure that your powerproject data lines up exactly with you spreadseet columns or your dates will be all over the place.
Best regards
Mike Testro