How can I repeat the copying of a worksheet?

M

mgarbanz

The work book I am creating has 100's of worksheets with the same format, but
different info. The inputing of data, as well as the linking is not an
issue. I want to repeat the copy function of a worksheet w/o having to right
click and do it manually everytime, but "F4" does not seem to help. I'm
confused, what keyboard function can do what I want to do?
 
G

Gord Dibben

If you just want to copy the sheet with its formatting but no data.....

Open a New Workbook, delete all but one sheet.

Format as you wish.

File>Save As>File Type>Excel Template(*.xlt)

Name it SHEET and store it in your XLSTART folder.

It will become the Insert>Worksheet default sheet.

SHIFT + F11 will insert a new sheet.


Gord Dibben Excel MVP
 
Top