HELP PLEASE!! PROJECTING A WEEK ENDING PRODUCTION DATE

P

Pete

Hi,
I want to run a pivot table on some raw data with the following variables:
'Account Customer', 'Order Date', 'Order Number', 'Item', 'Factory', 'Order
Qty', 'Exp Production Date (week ending)', 'Average weekly production by
Item'.

Currently the 'Exp Production Date (week ending)' is manually entered into
the raw data sheet.

I would like Excel to calculate the 'Exp Production Date (week ending)' in
the pivot table based on 'ave weekly production by item'. I was thinking the
ave weekly production numbers would be entered manually into a raw data
sheet.

Could you please advise how I can get EXCEL to do this?

Thanks so much!!!

Pete
EXCEL 2003, WINXP SP2, 1 GIG RAM,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP PLEASE! I NEED TO TELL THE FACTORY WHAT TO MAKE USING EXCEL!! 2
HELP PLEASE! - APPLYING A % COLUMN TO A PIVOT TABLE RESULT 1
Excel check if dates are under a range of week 4
How to display and store current Week Ending Date (Saturday's) 2
Pivot Table Sort 0
Calculating a week ending date 6
Week ending date problems 6
Production Scheduling Database 6

Top