Results 1 to 13 of 13

Create and sort Tabs

Threaded View

jsmity Create and sort Tabs 09-28-2011, 01:08 PM
davegugg Re: Create and sort Tabs 09-28-2011, 01:44 PM
jsmity Re: Create and sort Tabs 09-28-2011, 02:12 PM
davegugg Re: Create and sort Tabs 09-28-2011, 04:49 PM
jsmity Re: Create and sort Tabs 09-28-2011, 04:57 PM
jsmity Re: Create and sort Tabs 09-28-2011, 05:08 PM
jsmity Re: Create and sort Tabs 09-29-2011, 02:55 AM
davegugg Re: Create and sort Tabs 09-29-2011, 12:43 PM
jsmity Re: Create and sort Tabs 09-29-2011, 12:50 PM
davegugg Re: Create and sort Tabs 09-29-2011, 01:44 PM
jsmity Re: Create and sort Tabs 09-29-2011, 02:40 PM
  1. #1
    Forum Contributor
    Join Date
    01-28-2007
    MS-Off Ver
    2019
    Posts
    205

    Create and sort Tabs

    Attached is a "database" for Risk assessments. I want to make to mods and i'm after some guidance on how to do it:

    1) Have a button that creates a new dab based on the template "OperationalProcess HIRA" sheet and then prompts for a new name for the tab.

    2) For Quick access i've created a userform1 that opens with the workbook that is populated by all the worksheets in the workbook. What i want to do is for the operator to be able to filter these based on the sheet name prefix i.e - Asphalt , concrete , Aggregates etc. How can i do this from within the userform ?


    I know access would be the way to go but only a limited number of people within my company have access installed so it needs to be usable through excel.
    Last edited by jsmity; 09-29-2011 at 02:41 PM. Reason: solved

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