I have currently set up 6/7 spreadsheets, one for each team to monitor
productivity.
Each has a list of jobs down the left hand side, and the dates along the
top. Each day a new column is used.

Unfortunatly I have hit a problem. This morning I was increasing the sheet
right, so more days are covered, this way people only have to input the data,
not add the date, formatting and copy over total sums and such. I found
though that the spreadsheet only goes as far as IV, which is roughly 11 and a
half months of dates (don't have Sat and Sun)

Is there anyway of increasing this so it goes past IV as a maximum?
Vertically I am only using a maximum of 250 rows, so over 60,000 rows can be
sacrificed easily.

If not I'm left with either re doing all the sheets (which we've been using
for 2 months currently) or working out some complex copy and pasting system
that transposes the figures on a bi-monthly basis maybe... Hopefully
increasing the width of the sheets is possible though.

The current limit is 256 columns (i.e. column IV, as you have found).
The next version of Excel, due out sometime in 2007, will overcome this
limitation.

You might think about using two sheets, one for the first 6 months of a
year and the second for the other six months - this will reduce the
amount of re-coding you will have to do.

Hope this helps.

Pete

Current version of excel limits number of columns to 256. Try using a sheet
each for a month or so.

"PaulW" wrote:

I have currently set up 6/7 spreadsheets, one for each team to monitor
productivity.
Each has a list of jobs down the left hand side, and the dates along the
top. Each day a new column is used.

Unfortunatly I have hit a problem. This morning I was increasing the sheet
right, so more days are covered, this way people only have to input the data,
not add the date, formatting and copy over total sums and such. I found
though that the spreadsheet only goes as far as IV, which is roughly 11 and a
half months of dates (don't have Sat and Sun)

Is there anyway of increasing this so it goes past IV as a maximum?
Vertically I am only using a maximum of 250 rows, so over 60,000 rows can be
sacrificed easily.

If not I'm left with either re doing all the sheets (which we've been using
for 2 months currently) or working out some complex copy and pasting system
that transposes the figures on a bi-monthly basis maybe... Hopefully
increasing the width of the sheets is possible though.

If you genuinely will have a maximium of 250 rows, then transposing
columns and rows may be an option. Transpose arrays or macros may help
here if you decide to go down this path.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531840

Refer Dave Peterson posting under link below to transpose quickly and
effectively
http://www.excelforum.com/showthread.php?t=531894


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531840