Like Stacy mentioned, a PivotTable might be best, as it sounds like your main
issue is organizing data, since you input information manually anyways.

Note that to link to Project, copy from Excel, go to Project, then
Edit-Paste Special, Link as: Text.

Or, if you manage to do the reverse, its the same proceedure to go form
Project to Excel.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kburner" wrote:

The ideal situation would be to somehow tie this to Project and have the
information feed directly into the Excel doc.

"srd" wrote:

How are you getting the information that goes into the spreadsheet?
--
Stacy
MCDST


"Kburner" wrote:

Is there a template or some advice someone can provide to track products that
are being made by several different factories using Excel. I currently do
this with Excel but every change must be done manually. I am essentially
using Excel to print out the results. I would like to use the power of Excel
to track this information and make changes across the year by entering the
information in one place.