software

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.

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

quot;PaulWquot; wrote:

gt; I have currently set up 6/7 spreadsheets, one for each team to monitor
gt; productivity.
gt; Each has a list of jobs down the left hand side, and the dates along the
gt; top. Each day a new column is used.
gt;
gt; Unfortunatly I have hit a problem. This morning I was increasing the sheet
gt; right, so more days are covered, this way people only have to input the data,
gt; not add the date, formatting and copy over total sums and such. I found
gt; though that the spreadsheet only goes as far as IV, which is roughly 11 and a
gt; half months of dates (don't have Sat and Sun)
gt;
gt; Is there anyway of increasing this so it goes past IV as a maximum?
gt; Vertically I am only using a maximum of 250 rows, so over 60,000 rows can be
gt; sacrificed easily.
gt;
gt; If not I'm left with either re doing all the sheets (which we've been using
gt; for 2 months currently) or working out some complex copy and pasting system
gt; that transposes the figures on a bi-monthly basis maybe... Hopefully
gt; 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: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531840
Refer Dave Peterson posting under link below to transpose quickly and
effectively
www.excelforum.com/showthread.php?t=531894--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531840