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.

Is there a particular part you're having a problem with?

Tim

"Sinner" wrote in message
...
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.

Dear Tim,

I didn't get what you meant by particular part? : )

All I require is a form that would enable me to tag a db being
maintained in xl.
I already have a xl based db which I tag manually. I want it to be
through a form to save time.
Dnt wanna have it in access.

Thx

On Feb 3, 11:10*pm, "Tim Williams" <timjwilliams at gmail dot com
wrote:
Is there a particular part you're having a problem with?

Tim

"Sinner" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

Your question is a bit too big/broad. It is like asking how do I build a
car?
Best is maybe to find a good example on the net.
Search for something like: Excel form data input example.

RBS

"Sinner" wrote in message
...
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.