+ Reply to Thread
Results 1 to 1 of 1

Build one database from another using search and add

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Adelaide
    MS-Off Ver
    Excel 2019
    Posts
    79

    Build one database from another using search and add

    G'day again excel forum

    I've been toying around with some spreadsheets to help a mate out at work and I’ve hit a wall with one of them.

    I was wondering if it is possible to add a 'Search and Add' function to an excel spreadsheet to build one database from another.

    Ideally I’d have this setup so a user could search one database sheet for an entry and then have a clickable object (a button of some kind) adjacent that when clicked will add that entry to another dataset. The user could then search again and add another entry underneath the previous one, building the new database incrementally until reaching the last row (in the case of the attached spreadsheet example there are only 6 rows).

    I hope the attached example makes more sense of this.

    I don't know if this can be achieved using forms, or with some kind of filter or even at all.

    Cheers for any advice on this issue

    MattRNR
    Attached Files Attached Files

+ 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. Build second version of database - Best way to do it
    By colemauro in forum Excel General
    Replies: 2
    Last Post: 10-06-2015, 08:06 AM
  2. Simple Database Build
    By andyaf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2013, 02:42 PM
  3. Build a budget database
    By ulsterboy84 in forum Excel General
    Replies: 0
    Last Post: 05-12-2012, 01:59 PM
  4. Build an efficent database
    By ExtraExcelly in forum Excel General
    Replies: 0
    Last Post: 10-20-2009, 10:16 AM
  5. Need Help to build a news articles database
    By sandydude4u in forum Excel General
    Replies: 1
    Last Post: 05-13-2009, 06:53 AM
  6. [SOLVED] I want to build a database
    By Bill in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-15-2006, 10:30 AM

Tags for this Thread

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