Dan Dungan wrote:

I'm posting here because I think may plan will need vba. I've tried
developing in Access, but the boss wants excel.

Why? IMO, your requirements below are more suited to a database than a
series of spreadsheets.

I've looked for code
to use for looping through spreadsheets, but I haven't found an idea
yet. I don't know how to write the code for my plan.
-------------------------------------------------------------------------
----------------------------------
Details:
We're using Excel 2003 on windows xp.

The boss wants to use excel to summarize material use in our plating
department.

We have several plating codes. Each plating code represents a process
the uses several tanks of differing solutions. Each tank has a code.

The same tank may be used in several processes.

We will determine the weight for each job and assign a load number.

We want to get a total weight of material that passed through each
tank and receive a notice when the total reaches 200 pounds.

The boss wants the administrator to enter the weight for each load
daily. There may be more than one load per day. Then he wants the
spreadsheet to add that weight to each of the tanks used in that
specific plating code.

Then he wants a summary that shows the total weight for all tanks.

There are several tanks, I haven't been able to determine the total
quantity of tanks yet. Here's a partial list of Tank names:

A20,A17,A18,A19,B11,B12,B13,B14,B19,B21,B22,B23,B2 4,B25,B27,B28,B29,B30,B
31,B32,B33,B34,B35,B36,B37,B38,B39,B40,B42,B43,B44 ,B45,B46,B47,B48,B49,B5
0,B51,B52,B53,B54,B55,B60,B61,B62,B63,B65,B66,B67, C1,C10,C11,C12,C13,C16,
C17,C19,C2,C20,C21,C27,C3,C4,C5,C6,C7,C8,C9

Here's a partial list of plating codes:

10,10A,24,25,30,30A,30B,48,87,90,99

Here's a partial list of tanks used in plating codes:

10A
B35 B36 B37 B38 B39 B40 B21 C10

24
B27 B28 B29 B30 B31 B32 B33 B34 B44
B46 B45 B47 B48 B49 C16 B50 C17
B51 C19 B52 C20 B53 C21 B54 B55
C11 C12 C13 C10 B19

30
B35 B36 B37 B60 B61 B62 B63
-------------------------------------------------------------------------
---------------------------------

Have you asked anyone? I bet that someone, somewhere, has complete lists of
tanks and plating codes.

Proposed plan:

So what feedback do you have for the following plan?

Each spreadsheet in the workbook represents activity for one plating
code.

Populate the column headers with the tank names used in that plating
code's process.

Include a column for date and a column for load number.

The administrator enters the date on the next row in cell A, then
enters the load number in cell B, then the weight in Cell C. The
spreadsheet fills that amount for all the tanks in that process.

After all the jobs are entered for the day. The administrator runs a
macros that loops through the workbook to determine the total for each
tank and put that amount another sheet--the summary sheet which will
have every tank listed in the header column.

If I were to do this, I would probably go with an Access backend (unless I
decided a more powerful db engine was needed, in which case I'd likely use
MySQL) and tell the boss to go f*** himself. Then I'd just pull the data
from the db as needed.

--
None of you understand.
I'm not locked up in here with you.
*You're* locked up in here with *me*.