View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default add a sheet button

First of all......workbooks are comprised of one or more worksheets, not
"pages".

Pages are what you print on your printer.

Secondly......do you want a fesh, clean copy of Customer Info which presumably
has been formatted as you want?

I assume the original Customer Info sheet has been filled in with customer #1
info and now you want a customer #2 info sheet ready to be filled in.

You could just drag the Customer Info sheet to the right or left then drop it
where you want and hold CTRL key and drop the sheet which would create a copy.

Then clear the entered data from customer #1

Or you could a Template of the Customer Info sheet which you insert.

How do you want to proceed?


Gord Dibben MS Excel MVP

On Sat, 1 Dec 2007 14:07:01 -0800, vdmbqb
wrote:

I have a two page workbook. Page 1 is instructions for the information
expected on page two. Page 2 is called Customer Info.

I would like to have a button on page 1 that I could simply click on that
would add another Customer Info page with each click.