GregR

Posts: n/a

Add Sheets and rename

I have a workbook with one sheet named Sept. I want to add 11 more sheets,
name them Oct - Aug and copy the contents of the original sheet to the new
sheets. Then change the value in A3 of each sheet to the sheet name. The
name of the initial sheet should be optional. If it was name Jan, the added
sheets would be Feb - Dec. TIA

Greg

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RENAME SHEET TABS AOYUMATICALLY	RENAME SHEET TAB NAMES VIA MACRO'S	Excel Discussion (Misc queries)	3	February 3rd 05 01:06 PM
Can I batch rename new worksheets	Harry Limey	New Users to Excel	3	January 19th 05 09:19 PM

All times are GMT +1. The time now is 09:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us