Results 1 to 5 of 5

VBA copy MASTER sht when new entry to the table is made and name it as the cell value

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2010
    Location
    Worcester, UK
    MS-Off Ver
    Microsoft 365 (subscription)
    Posts
    50

    VBA copy MASTER sht when new entry to the table is made and name it as the cell value

    I need help a.s.a.p. please.

    I would like to be able to have a macro, working automatically, so that when you add next entry in the table it creates a copy of MASTER sheet and name it as the cell value.

    I.e. If I add following data in the table:
    Argentinos Juniors (A2)
    Volga Novgorod (A3)
    Real Salt Lake (A4)

    it (macro) automatically creates 3 sheets (copies of MASTER sheet), name them as the cell values (so Argentinos Juniors, Volga Novgorod and Real Salt Lake) and put it's (sheet) name in cell B1 of this sheet.
    Also in SUMMARY sheet table is filled in automatically with cells in columns B i C (formulas as in above row).

    I need also something to protect already created inputs (and sheets) so if somebody is altering (or deleting) any record in the table macro is asking if the sheet name needs to be changed or sheet needs to be deleted and deleting it (or changing name).
    For duplicate input (so if someone will input for example Argentinos Juniors again) it needs to create sheet named Argentinos Juniors 2, Argentinos Juniors 3 etc... and changed input in column A so it will be also Argentinos Juniors 2, Argentinos Juniors 3 etc.

    Thanks for any support!
    I have attached sample workbook so it will be easier to understand what I need... hopefully.


    Also posted on bigresource.com:
    http://excel.bigresource.com/Track/excel-ej1s98DX/
    Attached Files Attached Files
    Last edited by jarssonn; 06-03-2011 at 01:58 PM.

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