Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Add Sheet Named As Cell Value If Not Present Already

  1. #1
    Join Date
    17th July 2008
    Posts
    1

    Add Sheet Named As Cell Value If Not Present Already

    I have 1 workbook is Quotation and already created a "Save Button" for correct all worksheet into 1 workbook. When after click save i need excel create a new worksheet with a no. based on specific cell is "K17"(QT no.) and check duplicate. Thank you in advance for the suggestion.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    11th December 2007
    Posts
    36

    Re: Create A New Worksheet With Specific Cell

    English is 1st language? Righto.

    Can you please expand your question a little more? We will find it very hard to help unless we understand what you need.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,678

    Re: Create A New Worksheet With Specific Cell

    Hi,

    May be..
    VB:
    Dim ShtName As String, NewSht   As Worksheet 
    ShtName = Range("K17") 
    On Error Resume Next 
    Set NewSht = Sheets(ShtName) 
    On Error Goto 0 
    If NewSht Is Nothing Then 
        Set NewSht = Worksheets.Add 
        NewSht.Name = ShtName 
    Else 
        MsgBox "Sheet '" & ShtName & "' already exists", vbInformation 
    End If 
    
    

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Delete Sheet Named In Cell
    By TheDude in forum Excel General
    Replies: 3
    Last Post: August 26th, 2008, 04:01
  2. Sheet Named From Cell
    By Windy58 in forum Excel General
    Replies: 2
    Last Post: November 26th, 2006, 00:18
  3. Add/Insert Sheet Named Off Cell
    By Syntinal in forum Excel General
    Replies: 3
    Last Post: October 6th, 2006, 16:37
  4. Paste to Sheet Named in Cell
    By kevfeng in forum Excel General
    Replies: 5
    Last Post: June 4th, 2005, 12:12
  5. Looking up a name in a sheet and adding it if not present
    By kitty_cat in forum Excel General
    Replies: 2
    Last Post: May 26th, 2005, 00:45

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno