Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2015, 04:23 PM
robbinskelly7 robbinskelly7 is offline Automatically have Percent Complete filled by Excel data Windows 7 64bit Automatically have Percent Complete filled by Excel data Office 2013
Novice
Automatically have Percent Complete filled by Excel data
 
Join Date: Feb 2015
Posts: 2
robbinskelly7 is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 02-10-2015, 03:14 PM
JulieS JulieS is offline Automatically have Percent Complete filled by Excel data Windows 7 64bit Automatically have Percent Complete filled by Excel data Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically have Percent Complete filled by Excel data Assigning Resources and percent complete jwindholz2725 Project 1 02-24-2014 10:56 AM
Automatically have Percent Complete filled by Excel data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft