C
Camille P
Hello again,
Firstly, apologies for the long post. Secondly, if this query should be
redirected more appropriately elsewhere, please let me know.
Using Win/Word 2000 (shortly to be upgraded to Win XP/Office 2002 and then
2003 next year) I know I'm getting into database territory here, but
unfortunately we need a quick solution until we can build a database for our
purposes. I'm more a Word person, so please bear with me while I try to
explain and hopefully someone will be able to help...
I have an Excel Workbook that contains 4 Worksheets. Data is entered into
Worksheet 1. With some cells within Worksheet 1, the user needs to link to
data in Worksheets 2 and 3 (Worksheets 2 and 3 are basically list
information only). Data in Worksheet 4 is linked to information in Worksheet
1 ONLY (i.e. Sheet1!A2). Basically, it is pretty much set up like linking
tables in a database. The purpose of linking this way is to ensure data
consistency and to avoid having the user input information multiple times.
So, my problem... a Worksheet in this document holds information as to where
scanned documents are held. Each scanned document has a number based on
Department.DocumentType.DeptDocNumber. The DeptDocNumber represents that it
is say, the 3rd, document for that _Department_ we have scanned. This number
must be unique to each Department, but not unique compared to other
Departments. So, document numbers ultimately look like
Dept.DocType.DeptDocNo (or AA.D001.001). As I am dealing with several
Departments, there may be several DeptDocNo's numbers called .001. Is there
a way in Excel to warn the user that a DeptDocNo for a particular Dept is
already in use? i.e. is it possible to warn the user that the DeptDocNumber
"001" has already been used for Dept AA?
Even better, in the Worksheet that holds the Department numbers (which I've
set up to hold a column that has the latest DeptDocNo used which will
increment by 1 when double clicked), is there a way to read the
DeptDocNumber and automatically increment the numbers for a particular
Department? I'd like to automate this to avoid user errors.
I hope I'm making sense.
Thank you!
Regards
Camille
Firstly, apologies for the long post. Secondly, if this query should be
redirected more appropriately elsewhere, please let me know.
Using Win/Word 2000 (shortly to be upgraded to Win XP/Office 2002 and then
2003 next year) I know I'm getting into database territory here, but
unfortunately we need a quick solution until we can build a database for our
purposes. I'm more a Word person, so please bear with me while I try to
explain and hopefully someone will be able to help...
I have an Excel Workbook that contains 4 Worksheets. Data is entered into
Worksheet 1. With some cells within Worksheet 1, the user needs to link to
data in Worksheets 2 and 3 (Worksheets 2 and 3 are basically list
information only). Data in Worksheet 4 is linked to information in Worksheet
1 ONLY (i.e. Sheet1!A2). Basically, it is pretty much set up like linking
tables in a database. The purpose of linking this way is to ensure data
consistency and to avoid having the user input information multiple times.
So, my problem... a Worksheet in this document holds information as to where
scanned documents are held. Each scanned document has a number based on
Department.DocumentType.DeptDocNumber. The DeptDocNumber represents that it
is say, the 3rd, document for that _Department_ we have scanned. This number
must be unique to each Department, but not unique compared to other
Departments. So, document numbers ultimately look like
Dept.DocType.DeptDocNo (or AA.D001.001). As I am dealing with several
Departments, there may be several DeptDocNo's numbers called .001. Is there
a way in Excel to warn the user that a DeptDocNo for a particular Dept is
already in use? i.e. is it possible to warn the user that the DeptDocNumber
"001" has already been used for Dept AA?
Even better, in the Worksheet that holds the Department numbers (which I've
set up to hold a column that has the latest DeptDocNo used which will
increment by 1 when double clicked), is there a way to read the
DeptDocNumber and automatically increment the numbers for a particular
Department? I'd like to automate this to avoid user errors.
I hope I'm making sense.
Thank you!
Regards
Camille