View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dane Dane is offline
external usenet poster
 
Posts: 14
Default Auto Create New Page In Worksheet

I have created an Order Form That has info in the first 16 rows pertinent to
'sold to', 'ship to', etc. - then there are 20 rows of empty cells to enter
items being ordered - then the bottom rows conatain 6 rows of info pertinent
to the order like tax, freight, totals, etc.

I would like to keep the same worksheet for additional pages when needed, by
inserting pages as required - 2, 3, 4, etc.

Is there a macro that I could ceate or is there another way to accomplish my
task.