Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help. This is way too tough for me.
I have a HUGE spreadsheet, 212 tabs at the bottom.
I need to do a lookup to bring that data, from multiple cells, into a master sheet. My information is as follows: 1st tab: Jan 1990 2nd tab: Feb 1990 3rd tab: Mar 1990 4th tab: Apr 1990 Through current Month and Year. Each sheet is as follows: cell A1 cell B1 cell C1 cell D1 cell E1 cell F1 cell G1 cell H1 3092323 hammer green 2 $14.34 pr 87 Jan cell A1 cell B1 cell C1 cell D1 cell E1 cell F1 cell G1 cell H1 4456782 tape yellow 47 $3.71 ea 14 Jan and so on, to fill 65,536 lines down by 31 lines across.(lots of information) I want to bring the information, 8 of the 31 lines/cells across, from each of the 212 tabs/sheets in this workbook and have them auto update the master sheet information that is already put into a master sheet, as a count to the appropriate cells, as follows: cell A1 cell B1 cell C1 cell D1 cell E1 cell F1 cell G1 cell H1 4456782 tape yellow 47 $3.71 ea 14 Jan cell A2 cell B2 cell C2 cell D2 cell E2 cell F2 cell G2 cell H2 4456782 tape yellow 47 $3.71 ea 23 Feb cell A3 cell B3 cell C3 cell D3 cell E3 cell F3 cell G3 cell H3 4456782 tape yellow 47 $3.71 ea 47 Mar and so on - basically I want to count, from each month tab and each year tab, how many of each part went in each month and year, so I can build a trend for inventory. This is huge and I have no idea how to do it, so I do realize that this is beyond what I know. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tough one | Excel Discussion (Misc queries) | |||
Tough one: | Excel Discussion (Misc queries) | |||
OK tough one ! | Excel Worksheet Functions | |||
Tough one... | Excel Discussion (Misc queries) | |||
Tough one | Excel Discussion (Misc queries) |