Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel: Need help with macro for data management

    I have a problem with data management. Hope I can get help for this, so I'll be able to apply it on my database.

    I have 3 workbooks (only 1 worksheet each) with 2 fields: Name & Data. The "Name" field writes "Example A", "Example B" & "Example C", and the name of the file is the same as the name (i.e. "Example A", "Example B" & "Example C").

    I want to create a data mangement workbook that does the following:

    1. List out the names of the workbook in my database. For example:
    _____Serial Name
    _________1 Example A
    _________2 Example B
    _________3 Example C
    2. Search function so that when I click the icon "Search", I can type in "Example B" and it opens the workbook in a new sheet.
    3. New entry function so that when I click the icon "New", I can create a new workbook in the same format (i.e. single worksheet, 2 fields) into my database.

    Please help!!!!

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,224
    Thanks
    14
    Thanked 341 Times in 334 Posts
    I don't completely understand what you are after. I would recommend, if you want to accomplish a data management workbook to create one workbook and combine all the worksheets into 1 database. If desired you could have a third field named "Example" with A, B, C as the entries. This would allow analyses of all the data using autofilter and subtotals to recreate the look of the individucal sheets and even the use of a pivot table.

    In particular, I do not understand #1 or what exactly you need help with.
    Items #2 and 3: Excel already has built in routines for searching and creating a new workbook. If you want to create specific routines, could you please clarify exactly what the routines should do. When you enter in "Example B" what is exactly to be searched. And For #3 what does creating a new workbook into your database mean exactly?

    Steve

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •