Making Me Crazy ~ Please Help...

C

Champ

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?
 
F

Fred Smith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top