Ok U have a book with two sheets.
Sheet one has a produciton total at the end of the row.

Say the production total is Q1 on Sheet 1
on Sheet 2
there are for col's
Week 1 Week 2 Week 3 Week 4

BAsed on the date of the report I have a cell in sheet 2 that
will display the correct week, in c3

I would like to match c3 that tells the week I need and then
have the production form sheet one put in the appropriate col.
so if c3= week 1
The production # from sheet one will only be displayed if it is infact week 1