Hi Guys

I'm sure "no" is probably the answer to the question, but its always worth a
try!

I've been putting together a workbook with the original intention of having
a worksheet for each of our customers holding details of equipment they have
on a maintenance contract.

I've created 3 worksheets - the 1st is called Picklist and just has 2
columns (item and price), the 2nd is called Customers and has about 15
columns holding details about all our customers (e.g. name, address etc) and
the 3rd is the actual contract "template".

I've created the "template" so that I can cut down on the great deal of
typing usually necessary when renewal times come around, and have used
VLOOKUP as much as possible to pull information from the Picklist and
Customer worksheets.

I had intended to keep the original contract worksheet blank and then copy
it to a new one for each customer.

Now comes the big BUT...

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. (Quite infuriating since a
large portion of the Contract worksheet is text, which probably means our
contracts are incredibly waffly, but as I'm no legal eagle I'm not about to
mess around with legal speak!)

So...I was wondering whether I could save the Contract worksheet as a proper
Excel template and take it out of the workbook altogether, so just leaving
Picklist and Customers, but still be able to use VLOOKUP to reference them?

If anybody knows, or, if anybody has a much less convoluted idea for doing
what I need to do then I'd be grateful if you could put me out of my misery!

Many thanks!

Ali