Oops. I meant "worksheet". Exactly. I would like to launch a template
with the formatted cells in place and only carry over the final total to
the template.

Thanks again Gord.


Gord Dibben wrote:
By "spreadsheet" I will assume you mean "worksheet" in a workbook.

When a certain cell contains a final total determined by you or by a calculated
value you want the sheet copied?

What part or parts of the sheet do you want copied? Do you want to create a
copy of the sheet with no data................like a template?

You speak of carrying over the total to the copied sheet........if you copied
the entire sheet then the total would go with it................right?

So what exactly are you asking for?


Gord

On Sun, 10 Jul 2011 13:26:55 -0500, Jennifer wrote:

Thanks for responding Gord. What I'd like to do is when the total sum
of one spreadsheet is completed, I'd like to program that cell to launch
a copy of that spread sheet and carry over that total to the copied sheet.

Gord Dibben wrote:
Check out VBA help on worksheet events..........specifically rightclick or
doubleclick events.

Or post with some details of your needs and perhaps you can get a tailored
resolution.


Gord Dibben MS Excel MVP


On Sat, 09 Jul 2011 13:20:49 -0500, Jennifer wrote:

Hi,

Does anyone know of a simple way to launch spreadsheet copy from a cell?