Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anyone help please
I have 4 worksheets MASTER SHEE Project, Date, Sum of Description of change 100, 12/5/2006, Changed the Date and Changed the number 200, 12/5/2006, Changed the Date and Changed the number and Changed th ship to 300, 12/5/2006, Changed the number 400, 12/5/2006, Changed the Date and Changed the number 500, 12/5/2006, Changed the Date and Changed the number 600, 12/5/2006, Changed the Date and Changed the number SHEET Project, Date, Description of change 200, 12/5/2006, Changed the Date 300, 12/5/2006, 100, 12/5/2006, Changed the Date 400, 12/5/2006, Changed the Date 500, 12/5/2006, Changed the Date 600, 12/5/2006, Changed the Date SHEET Project, Date, Description of change 200, 12/5/2006, Changed the number 300, 12/5/2006, Changed the number 100, 12/5/2006, Changed the number 400, 12/5/2006, Changed the number 500, 12/5/2006, Changed the number 600, 12/5/2006, Changed the number SHEET Project, Date, Description of change 200, 12/5/2006, Changed the ship to 300, 12/5/2006, 100, 12/5/2006, 400, 12/5/2006, 500, 12/5/2006, 600, 12/5/2006 The above sheets have three columns: Project number, date, Descriptio of change. I would like to some how automate Sum of Description o change (Column C) on Master sheet, to sum up the changes on sheet 2,3, according to the project number. Note the project number is going to b on different lines then the master sheet -- mister ----------------------------------------------------------------------- mister z's Profile: http://www.excelforum.com/member.php...fo&userid=2809 View this thread: http://www.excelforum.com/showthread.php?threadid=48334 |