updating a database from different sheet..

Good Day everyone!

I hope someone can help me here. What I want to do is to update a database on a hidden sheet from a different sheet. Basically the program should run like this... (I attached the file) If i put the scientific name on the c2 cell, c3-c7 cells will be populated with data from the database (supposed to be hidden database). And if some entries are missing, i can fill it up in "updating" sheet and click a button and it will be copied/updated automatically to the "database" sheet. Is it possible? Thanks everyone, hope someone could help me... I've stuck here for a long time

1) Press CTRL-F3 and create this named range:

Names In Workbook: ScientificNames
Refers To: =OFFSET(DataBase!$A$2,,,COUNTA(DataBase!$A:$A)-1,)

2) Select Updating cell C2 and apply these Data Validation settings:

Allow: List
Source: =ScientificNames

3) Right-click the Updating sheet tab and select VIEW CODE, then paste in this event macro:

Please Login or Register  to view this content.

4) Close the VBEditor
5) Hide the Database sheet
6) Save your workbook as Data.xlsm (macro-enabled workbook)


Now try out the Updating sheet starting with the new Drop Down in C2.