Excel to track product delivery

[Kburner]

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.

 

[srd]

How are you getting the information that goes into the spreadsheet?

 

[Kburner]

I enter the information directly. I use different colors for differnt
factories. Ideally, I want to be able to see just one factory delivery
schedule at a time but I also want to be able to see all of the factories
combined into one schedule.

Kevin

 

[Kburner]

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

 

[srd]

I am not exactly sure what you are trying to do but maybe putting your
information into a pivot table will help. It makes sorting, grouping,
analyzing and manipulating data a lot easier than some of the other excel
methods.

I thought Pivot tables were scary before I started using them but now, they
are the easiest thing to use! It just take a little practice.

If you would like to send me an example of your data, send it to
stacy.downing at hotmail dot com

 

[Luke M]

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.