On Mon, 5 Sep 2005 13:56:01 -0700, Edgentrib
wrote:

Employees earn gift cards each day of the year for performance. We use excel
to track who we issue to and how much each person gets.

Paper sheets are printed out for each week and employees sign the sheet when
they receive the gift card.

The problem is that we do not have enough columns on a worksheet. I would
need to go to a second sheet. This is inconenient and risky. Especially if
you add or delete employees on one sheet, it is does not automatically happen
on the secon sheet.

What add-in do I need to add about 150 columns on a worksheet?


It's not immediately apparent exactly how your s/s is operating, but
I'm interpreting this to mean that you're using columns for employees
and rows for days?

You are in any case limited to 256 columns per sheet, but it sounds
like a re-design of your application is needed and your data at least
arranged in rows in a database table. You should think about a
'record' for every event per employee. e.g.

Employee, Date, No of Cards, Card Value

If the number of projected records is greater than the 65536, then you
should seriously consider a pukka database application.

HTH

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions




__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________