+ Reply to Thread
Results 1 to 2 of 2

Macros to Group Tabs, Delete Row, and Ungroup Tabs Required???

  1. #1
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Macros to Group Tabs, Delete Row, and Ungroup Tabs Required???

    Hi All,

    Hopefully someone can help with this query.

    I have a spreadsheet with the below macros that, groups tabs, add a row across the tabs at the selected row on the front tab and also copies the formula from the above line.

    Please Login or Register  to view this content.
    Users of the sheet have run into issues where they add erroneous data and then need to delete said row, but they require the delete across all tabs to ensure all data (including manually inputted data) remains in the repective row throughout the workbook tabs.

    So in a nutshell what I need is the following:

    A macros button that will allow the user to select the erroneous row in the Database sheet ('Patient_List' as above), hit the button to group all tabs, delete the selected row across all tabs, then ungroup tabs returning the spreadsheet to its original state.

    Thanks
    seash
    Last edited by seash; 06-10-2015 at 06:27 AM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macros to Group Tabs, Delete Row, and Ungroup Tabs Required???

    Something like this;
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. Macro help: Separating data into tabs and creating a table of content of those tabs
    By AntiPivotTable in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2015, 11:57 AM
  2. Group same value in A column and write them in different Tabs
    By ghostexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2015, 08:54 AM
  3. [SOLVED] Userform with Multi-Tabs and Textboxes losing values when switching tabs
    By guitarsweety in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-23-2014, 11:35 AM
  4. Replies: 6
    Last Post: 02-01-2012, 05:29 PM
  5. VBA to hide group of specific tabs
    By deucejmp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2011, 09:48 PM

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