In xl workbook I have 15 worksheets. I have a list in column3 in each
sheet. The list can be at random or in order with unique entries. I
use "ctrl+f" to find a number in column3 which can be a range as well.

Column3 [1,2,3,4,5,6,7,8,9,10]
Column7 [Issued-SSC or Issued-CORP]
Column8 [Issuance date]
Column9 [Reference#]

In column7 I tag it as "Issued-SSC" & "Issued-CORP".
Column8 is date as I want it to be.
Column9 is a reference# column.

I need a form which would automate a simle routine.
The form should have "Starting Range", "Ending Range", "Ref#" and
"date" text boxes, and a dropdown to select "Issued-SSC or Issued
CORP". On "OK" it should find the range in column3 and see if all
other columns are blank & only then mark column3 items accordingly. If
columns are not blank, then it should return error message "Already
issued - ref#" showing the reference from column9.

Would appreciate if a text file summary report can also be populated
for the date.