sorting and filtering data

[cpe.ppl]

hi ,
having a liitle problem, i have attached a sample cut down example of my schedule.
i recieve a weekly schedule from a customer with demands for up to a month
what id like is a formula that will look for exact part number in row B and just replace figures in rows c-g form customer shedule on sheet 2 ,
as you will see there is less parts in sheet 2 and some of which have no reqirements over the next 4 weeks , so i,d like this either to be left blank or have a 0 value in them.
i need to keep the part number static in sheet 1 because they will be used to make other calulations..
thanks for looking
paddy...

[sktneer]

Try this......

Please Login or Register  to view this content.

And then copy across and down.

Please find the attached sheet to see if this what you want.

[protonLeah]

Please Login or Register  to view this content.