Where did you get this idea?

Copying a worksheet does restrict you to 255 characters in a cell.

Copying a cell from worksheet A to Worksheet B does not restrict you to 255
characters in a cell.

Aside from this, maybe save the 3 sheets as a Template(*.xlt) with the Contract
sheet blank except for formulas and formatting.

When you select FileNewTemplate and click on your template, a workbook will
open based upon that Template.

Fill in the Contract sheet for a customer and save.


Gord Dibben MS Excel MVP

On Mon, 5 Feb 2007 14:06:00 -0800, MeWivFree
wrote:

BUT, I've now discovered that you can't copy a worksheet and keep all the
data in cells that have more than 255 characters.