+ Reply to Thread
Results 1 to 19 of 19

VBA Delete the name out from table

  1. #1
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    VBA Delete the name out from table

    Dear all Friend & Expert,

    I would like to make the VBA that after we add sheet in each cells and named in the sheet "main" that we add,
    then need the name appear in table the same with sheet name, only one name in each sheet
    in this VBA attached file only add sheet, not make the same format

    as attached file

  2. #2
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: VBA Delete the name out from table

    Good Morning Yukioh.

    I'll give you a hand. Could you confirm for me what you would like to do?

    You enter the details into the main sheet, then run the macro and it auto fills a template, based on the data from the Row and names the new sheet after the Name in column B

  3. #3
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Cool Re: VBA Delete the name out from table

    I've done what I think you were asking for. If there's anything else please just fire me a message.

    If this was helpful to you please click the 'Add to Reputation' Star

  4. #4
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    Hi Richtea88

    i have run on your code , there is some error,
    how to do?

  5. #5
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: VBA Delete the name out from table

    select a cell on the row you'd like a new page for then click button 1.

    If it doesn't work can you send be the line of code that is causing the error

  6. #6
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: VBA Delete the name out from table

    I've added another Error handler to stop an error occurring when you select and invalid row

  7. #7
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    now is working,
    if i need another click on button 2 then let VBA add all sheet automatic how to do?

  8. #8
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: VBA Delete the name out from table

    Just Click Button 1

  9. #9
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    RichTea88,
    i just click it button 1, it added with all sheet, but without the name in table
    Last edited by yukioh; 01-17-2014 at 12:43 PM.

  10. #10
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    RichTea88,
    i just click it button 1, it added with all sheet, but without the name in each sheet in table

  11. #11
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    Hi all,
    regarding to the VBA of RichTea88, I have try a VBA that RichTea88 help me, it work well,
    but in the sheet that already created , it was no :
    1) no any name in table after created sheet
    2) when i double click on " button 1 " is said " A Sheet with that name already exists " , but when i deleted some sheet it still said that the same

    as attached file

  12. #12
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    ... some body help me pls

  13. #13
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,370

    Re: VBA Delete the name out from table

    Hi Yukioh,
    try it
    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    Hi Nilem,
    thank you so much for your kindly help,
    is it possible that can you explain the code for me....

  15. #15
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: VBA Delete the name out from table

    Good Morning Yukioh,

    Apologies for not getting back to you over the weekend. Nilem seems to have cracked this one for you, so I'll leave you in his capable hands!

  16. #16
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    Hi Nilem & All Expert

    after i try your code, it working well,
    and i need the VBA to add hyperlink to the "main" sheet in each name ( Aa,Bb...etc) in each name on table name, when click to the name then let it link to that sheet, how to do?

  17. #17
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: VBA Delete the name out from table

    Hi Yukioh,

    I think I've managed to get my one working for you with Hyperlinks.

    Give it a shot!

  18. #18
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    122

    Re: VBA Delete the name out from table

    thank you somuch RichTea88

  19. #19
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: VBA Delete the name out from table

    You're welcome Yukioh,

    If you're happy with the solution can you click the Add Reputation Star on my post and mark the thread as solved using the Thread Tools at the top?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete a Table
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-20-2013, 11:46 PM
  2. delete raw+pivot table
    By Nicolas6 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2012, 05:07 AM
  3. How do I delete a {=Table(A1)} function
    By Richard Buttrey in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-23-2010, 02:56 AM
  4. Delete Pivot table
    By hurriance in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2006, 04:10 AM

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