Extracting Data By Week #
 

The following is an extract from a 12 month worksheet

January Week This Month Cumalitive
Week No 1 2 3 4 4 January To Date
Quantity 22 34 55 77 77 188 188

Row 2 is the week #'s.
Cells B3:E10 will contain the quantities

When the week # is typed in cell F2, I want the macro to select the
following data and put it into the detailed cells
For week #4
the contents of cell E3 is put into cell F3
the contents of cells B3 to E3 are added together and the result is put into
cell G
the contents of cells B3 to E3 are added together and the result is put into
cell H3

the contents of cell F3 is only applicable to the quantities produced for
that particular week
the contents of cell G3 is only applicable to the quantities produced for
that particular month

the contents of cell G3 will change as the week # changes for that
particular month so as you go from weeek # 1 to week #4 there will be a
different quantty depending on the week #.

the contents of cell J3 is the overall quantities produced upto and
including the week# selected in cell F2

I want to be able to obtain this information for a full 52 week period when
the week # is typed in cell F2

Many thanks in advance for any help that you can provide.