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
Bookmarks