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