Need Excel help

[Shadow ÒÓ]

the attached form is my problem.

I fill out a daily like this after work. I'm wondering if there is a way to enter the numbers in the code field at the top, automatically fill themselves in at the bottom.

I have to use 8x6 instead of 8, 8, 8, 8, 8, 8 as there's no room in that code field.

If this makes any sense, is this possible?

[DeltaSierra]

I think I understand your question and I'm pretty sure it can be done. I'll play with it today (Sat) and see if I can figure out a nice easy way to do this. I'm assuming you don't want something big, ugly and complicated.

[Shadow ÒÓ]

ugly and complicated isn't an issue.......i'll hide all the codes anyway.

If I don't tally up the codes correctly and enter them at the bottom, I don't get paid. =)

[DeltaSierra]

I have a question for you. I sent you a PM. But, how many codes would you need to enter in the top part of the sheet? The maximum number?

I had to get help from my wife on this problem. She figured it out in less than an hour! But, she had to modify your spreadsheet. But it works nicely!

[Shadow ÒÓ]

I'd guess the maximum number of codes I'd ever enter would be 8, but there are several occasions I'll have to use multiples of the code number 8....(like I said above 8x6 or whatever)

[DeltaSierra]

Take a look at the first page of this spreadsheet. Is this what you had in mind?

[Shadow ÒÓ]

that's VERY close, but the hard part is getting it to understand what 8x3 means.

there may be times I have to enter 8, 8, 8, 8, 8, 8, 8, 8, 1, 18, 13, 5. I don't have room for all of that, so I wanted to be able to put 8x8, 1, 18, 13, 5 in order for it to fit.

That's the part that stumps me. =(

Tell the wife I love her for her efforts tho. =)

[DeltaSierra]

We're still working on it. You're right about the 8x3 part. When you enter that, Excel assumes you've entered it as "text," not a numeric value. And, as text, Excel ignores it as far as calculating anything. However, we think we could completely revise the worksheet. What do you think of this thought: we could set up a row with the codes across the top i.e., 1, 2, 3, etc. Then beneath that header row would be the cells that you would enter the number of each codes. For example, under code "3", you would enter a 1; under code "8", you would enter a 3. Then the spreadsheet could do the rest of the work. That is, the spreadsheet would count the number of "8" codes, and then enter the grand total in the lower half of the page.

The drawback to this idea is that if this spreadsheet is a preprinted form that you've modified to fit on an Excel spreadsheet, then this "new" version won't look very much like your form. However, if you're just making up this form as you go, then we might have a viable idea. What do you think?

[Shadow ÒÓ]

I wouldn't know if this was a preprinted spreadsheet, as it's been emailed to me exactly the way you see it. I know they were very specific in saying I could not alter the form itself tho.

would it help if I used 8*3 instead of the 'x' or would excel still recognize that as text?

[DeltaSierra]

Well, that complicates things. The "*" won't work either. If you don't put an "=" sign in front of the the 8*3, then Excel will consider that text. If you DO put the "=" sign in front of 8*3, then Excel will consider that a forumula and change it to 24, not three counts of eight. If we can't alter the form (which doesn't surprise me), then we'll have to think of something else.