How can we get more columns on a spreadsheet, like 365 days/colmn
 

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?

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

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
__________________________

"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.
....
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?

There have always been only 256 columns in Excel worksheets, and it'd take a
major rewrite of Excel to provide more. Either learn to live with this
limitation or use different software to track this, e.g., Access or some
other database or a different spreadsheet, such as Quattro Pro or the
Windows port of Xess.

Also, never delete employees. If Mr. X earned a gift card on 12-Jan and
retired on 31-Mar, if you were doing a full year reconcilliation in the last
week of December, wouldn't you want to see the record for Mr X back in
January?

One logical workaround is a separate worksheet for each month, quarter or
half year with a full list of employees in a separate worksheet (with none
of them deleted during the year - the list can only grow, never shrink, from
1-Jan through 31-Dec), and pull employee names into the other worksheets via
formulas pulling from the list of employees.

I agree that more columns would be useful, but it ain't gonna happen any
time soon.