Hi Guys,

Been working around this database and got stuck with how to extract data from "PData" Sheet into the "Data" sheet based on date indicated in the DateForm.

Here's how it should work;

a. When I enter data into the "Data" sheet and click "Update" data would be transferred to the "PData" sheet (this is working)
b. Sometimes I need to retrieve rows of data from the "PData" sheet back, based on the date on the DateForm by clicking "Display PHA") (this is where I am stuck :-))

Can anybody please help me construct the correct VBA code for this?
After the data has been extracted the vacated rows in the "PData" sheet must be deleted.

I only need data from columns A to G to be displayed back into the "Data" sheet.

Really appreciate you help.

Thank youSample Database.xlsm