Posted to microsoft.public.excel.programming

Bearacade[_7_] Bearacade[_7_] is offline

external usenet poster

Posts: 1

Macro to Create Sheet & Duplicate Sheet

Sub Macro()

If Sheets("Sheet1").Range("A1").Value = "TOTO" Then

Sheets.Add
With ActiveSheet
Name = "TOTO"
End With

Sheets("Sheet1").Select

End If

If Sheets("Sheet1").Range("A1").Value = "TITI" Then

Sheets("Sheet1").Select
Sheets("Sheet1").Copy Befo=Sheets(2)

End If

End Sub

--
Bearacade

------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=549682

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
Macro to create new sheet	Kim	Excel Discussion (Misc queries)	5	April 25th 09 02:51 AM
Duplicate sheet, autonumber sheet, record data on another sheet	des-sa[_2_]	Excel Worksheet Functions	0	May 8th 08 06:56 PM
Macro - to copy duplicate rows to another sheet	[email protected]	Excel Worksheet Functions	2	April 19th 05 01:53 AM
How to create a Macro to Copy Information in one sheet to another sheet.	poppy	Excel Programming	3	July 28th 04 07:26 AM
Do you know how to create a new sheet in a file by macro?	dukejas[_2_]	Excel Programming	2	November 8th 03 12:56 AM

All times are GMT +1. The time now is 06:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us