Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 3092323 hammer green 2 $14.34 pr cell A1 cell B1 cell C1 cell D1 cell E1 cell 4456782 tape yellow 47 $3.71 ea 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 4456782 tape yellow 47 $3.71 ea cell A2 cell B2 cell C2 cell D2 cell E2 cell 4456782 tape yellow 47 $3.71 ea cell A3 cell B3 cell C3 cell D3 cell E3 cell 4456782 tape yellow 47 $3.71 ea 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. Was this post helpful to you? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
As you can tell by the dearth of responses you've received, this won't be
easy. Your best bet, in my opinion, is to hire someone who knows Access. It is much better at handling databases of this size than Excel. If that's not viable, your next best option is to convert to Excel 2007. It supports 1 million rows per sheet, so at least you can put a whole year on a sheet. In Excel terms, you want a Pivot Table solution. Pivot Tables will do everything you want and more. The only problem is that Pivot Table support for multiple sheets isn't that great. Regardless, you should create a sample Pivot Table for one of your sheets. By concentrating on only one sheet, you'll get to know the power of pivot tables. Once you've designed the table you want, post back asking for help on using multiple sheets in a Pivot Table. Regards, Fred. "Champ" wrote in message ... 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 3092323 hammer green 2 $14.34 pr cell A1 cell B1 cell C1 cell D1 cell E1 cell 4456782 tape yellow 47 $3.71 ea 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 4456782 tape yellow 47 $3.71 ea cell A2 cell B2 cell C2 cell D2 cell E2 cell 4456782 tape yellow 47 $3.71 ea cell A3 cell B3 cell C3 cell D3 cell E3 cell 4456782 tape yellow 47 $3.71 ea 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. Was this post helpful to you? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Driving me CRAZY~ please help | New Users to Excel | |||
Crazy If | Excel Worksheet Functions | |||
Pasting Graphs - making me crazy! | Excel Discussion (Misc queries) | |||
I'm going crazy here | Excel Discussion (Misc queries) | |||
This is crazy!!! | Excel Discussion (Misc queries) |