Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |