Results 1 to 13 of 13

Auto making of new sheet

Threaded View

  1. #1
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Auto making of new sheet

    I have a table on sheet 1.
    For what I want to happen I don't know if I have to use a makro (don't know how to use makros) or can I use some other functions.

    What I want to happen is:

    When I write 0001-2011 in colum 1 (cell A2 - example) I want when I hit enter a new sheet is made in this workbook named 0001-2011 and in the colum (cell - A2) I wrote 0001-2011 I want it to be a hiperlink to this sheet.

    Later on there will be like 250 Sheets named like 0001-2011, 0002-2011 and so on...
    And I also have a table that I want to be automated on this new sheet.

    Is this even possible?

    Idias, please

    Denis
    Last edited by stojko89; 01-13-2011 at 04:14 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1