HOW DO I DUPLICATE SHEET TO BOOK???

STEVE · Oct 2, 2006

HOW CAN I DUPLICATE 1 SHEET INTO 40 SHEETS?

ALSO, HOW CAN I NAME THE SHEETS TO BE SEQUENTIAL?
(FOR INVOICES)
I WANT TO ASSIGN THE 1ST SHEET AN INVOICE NUMBER, THEN THE REST WILL
AUTOMATICALLY FILL IN SEQUENTIALLY.

THANK FOR HELPING!

Marcelo · Oct 2, 2006

Steve,

for the invoices and other sequetial numbers
http://mcgimpsey.com/excel/udfs/sequentialnums.html

to duplicate a sheet click on the tab name press ctrl and drop to right.
Chip Person has a lot of tips to sort rename and etc
http://www.cpearson.com/excel/whatsnew.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"STEVE" escreveu:

STEVE · Oct 2, 2006

I don't know anything about macros, or where they even go.
Forget about the sequentialing....can SOMEONE STILL HELP ON AN EASY WAY TO
DUPLICATE 1 SHEET INTO 100 SHEETS????