#1
|
|||
|
|||
Automatically have Percent Complete filled by Excel data
I was wondering if there was a way that percent complete could be changed based on information that is documented in an Excel spreadsheet.
Right now an Excel document is used to keep up with how many of our products are being processed. I was hoping to use this data to determine the percent complete. Thanks! |
#2
|
|||
|
|||
You can import data from Excel to Project. Percent complete in Project is based upon duration - not upon number of products being processed. So, a direct update likely would not make a great deal of sense. It depends upon the structure of the Project file.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Assigning Resources and percent complete | jwindholz2725 | Project | 1 | 02-24-2014 10:56 AM |
How to automatically sum in excel for filtered data | msi_g | Excel | 2 | 08-05-2013 05:29 AM |
Excel cannot complete this task with available resources. Choose less data or close | YounesB3 | Excel | 1 | 11-16-2012 02:40 PM |
How can create a form in Word 2007 that can be automatically filled? | artistech | Word | 0 | 08-04-2010 01:05 PM |
Percent Complete doesn't change End Date?? | jrwpmw | Project | 2 | 03-11-2010 01:40 PM |