fareedexcel
Member
Hi Excelers,
I have an input and output sheet. Input sheet has 2 Data validation list and a Enter Quantity field where a RANDOM NUMBER can be entered. Once click the Enter button, this RANDOM NUMBER to be copied to the OUTPUT sheet with correspond to the 2 data validation selections.
Every time I choose a different validation criteria in the Input Sheet and provide a RANDOM NUMBER which should be captured in the OUTPUT SHEET once I click Enter Button.
Also I need an option to replace an existing value in the OUTPUT sheet in case if required.
Please support.
I have an input and output sheet. Input sheet has 2 Data validation list and a Enter Quantity field where a RANDOM NUMBER can be entered. Once click the Enter button, this RANDOM NUMBER to be copied to the OUTPUT sheet with correspond to the 2 data validation selections.
Every time I choose a different validation criteria in the Input Sheet and provide a RANDOM NUMBER which should be captured in the OUTPUT SHEET once I click Enter Button.
Also I need an option to replace an existing value in the OUTPUT sheet in case if required.
Please support.