I want to select any and only one fruit from an excel file, and once that selection is made, the fruit name along with its information gets assigned to a code next in line in a different excel file and those cells fill themselves with that information. Once that is done, the code # gets printed in the original excel file beside the fruit that was selected.

Images are below:

Capture1.PNG
Capture2.PNG

The VBA code to make the selection is already been written, so don't worry about that. FYI that code is:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Intersect(Target, Range("A2:A6")) Is Nothing Then
        Application.EnableEvents = False
        If ActiveCell.Value = ChrW(&H2713) Then
            ActiveCell.ClearContents
        Else
            ActiveCell.Value = ChrW(&H2713)
        End If
        Cancel = True
    End If
    Application.EnableEvents = True
End Sub