Asta Powerproject Member for 15 years 11 months Member for 15 years 11 months Submitted by Andrew Willard on Fri, 2010-11-26 13:21 Permalink Hi Christine, I would 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 Member for 16 years 6 months Member for 16 years 6 months Submitted by Christine P on Thu, 2010-11-25 16:46 Permalink Hi Mikeah well - copy & paste Hi Mike ah well - copy & paste it is thanks for the reply :) Member for 19 years 10 months Member for 19 years 11 months Submitted by Mike Testro on Thu, 2010-11-25 15:45 Permalink Hi Christine I do not know of 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 Log in or register to post comments
Member for 15 years 11 months Member for 15 years 11 months Submitted by Andrew Willard on Fri, 2010-11-26 13:21 Permalink Hi Christine, I would 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
Member for 16 years 6 months Member for 16 years 6 months Submitted by Christine P on Thu, 2010-11-25 16:46 Permalink Hi Mikeah well - copy & paste Hi Mike ah well - copy & paste it is thanks for the reply :)
Member for 19 years 10 months Member for 19 years 11 months Submitted by Mike Testro on Thu, 2010-11-25 15:45 Permalink Hi Christine I do not know of 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
Member for
15 years 11 monthsHi Christine, I would
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
Member for
16 years 6 monthsHi Mikeah well - copy & paste
Hi Mike
ah well - copy & paste it is
thanks for the reply :)
Member for
19 years 10 monthsHi Christine I do not know of
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