FilePage setupSheet nd set Rows To repeat

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ian Kentzer" <Ian wrote in message
...

If your question regards titles on pages printed previous answer is what
you need.

If your question is about duplicating complete sheets with formulas,
etc. the following is a non VBA way.

Create the first sheet with the formulas and formatting you wish
1) CTRL HOME to put cursor in top left
2) CTRL A to select all
3) CTRL C to copy
4) CTRL PAGE DOWN to select next sheet
5) CTRL V to paste everything in the next sheet.

If there are many sheets to populate, a macro will speed it up. Just
record the relevant portions. Another macro which runs the first macro
a fixed number of times also makes it easier.

One can adjust the number of sheets created on new file creation in the
options menu. Set it to the number of worksheets you need and then just
open a new file. Alternately one could INSERT WORKSHEET as part of the
above.

You may want to turn recalculation off temporarily to speed things up.


--
kghexce
------------------------------------------------------------------------
kghexce's Profile: http://www.excelforum.com/member.php...o&userid=29804
View this thread: http://www.excelforum.com/showthread...hreadid=516813