help required on retrieving saved record and populating cells

[tinkerbelle]

hi all, i posted earlier but i think my example was maybe too complicated to follow.
i am posting a smaller spreadsheet which i hope is easier to follow:

The user enters their details in th DataSheet page range B2:B5 the fills in the boxes underneath.

In this example, 2 records have been saved into the STORAGE sheet for 1/5/2012 and 1/7/2012.

My question is. Can a macro be set that would allow the user to enter data into section B2:B5 of the datasheet page and then retrieve all the data for that record, if it exists in Storage. ie: if it exists then the cells in DataSheet would be populated with the data.

Possible complicating factor is that B23 is a drop down menu. Other drop downs exist in the full version.

hope this is achievable.

many thanks in advance
Tinkerbelle x

[aussieboykie]

A macro to cross reference what the user enters with what is in Storage is not too complex.
How do you plan to trigger the macro? Worksheet_Change event?

Please Login or Register  to view this content.

Regards, AB

[tinkerbelle]

Thanks for the reply AB. The macro will be triggered by a command button. ie: the user would enter their details in range B2:B5 of Datasheet and then press a button to populate the cells if that set of details had already been entered. Ideally, if they hadnt been entered then it would return a message box saying something like "No details found".
many thanks for your help.