Get periodic data (1 year from entry via form) from a Database in a different sheet

[Raghav Chamadiya]

So, I have a material Inventory Maintaining excel file in which data is entered via a form. The form has a field which asks for Retention/Destruction from user and another field "Invoice number" which works as a unique id for the data row
All this data( and more) is stored in same workbook. What I want is, that if the user selects Retention, then the data should display in a separate sheet named "Reconciliation" exactly 1 year later until the user takes action on it, so the data should just keep on coming in new rows in the reconciliation sheet

Please guide me what should be done for this

 

[sijpie]

let me try to rephrase this:
You have a userform (is this a pop-up userform or is this a 'form'on a sheet?)
On the form there is a field 'Retention/Destruction'
If the user enters a date in the retention field, then (I assume after clicking the OK button) the data should be stored in the Reconciliation sheet in the row for the invoice Nr

Is this correct? Please confirm if pop-up form or sheet based form