I have a database-type table with names, numbers, addresses and what have you. I would like to make a second, single-rowed table that serves as an input platform and sends the input data to the first table (database). The input row spans A10-F10 and the database table spans A16-F1359.
Secondly, I should also like to make a searchbox for the database table that functions in the exact same manner as the built-in excel search menu thing, but is accessed through a cell (is a search box, after all), and also allows for the data pulled up to be edited with ease.
Are these things possible? New to excel, so if you think of something please keep that in mind.
How to migrate data to another table and use a search box?