acsishere
06-07-2008, 06:30 AM
Dear Friends & Gurus,
I have some 50-60 files in which data entry is done by individual users. I have a shared workbook (LISTS.XLS) - (sheet named ADMIN) - in which the data already available as follows:
colA / ColB
(Branch) / (Code)
IVA / 5587
IVA / 8788
VC / 6783
VC / 7329
VC / 9283
VB / 2638
IVA / 4792
IVA / 6879
..... ColB consist unique values. There is no repitition.
I have a set of files which are named after the values of the colA of Lists.xls - (i.e. I have files like VB.XLS, IVA.XLS, VC.XLS, and so on).
Now I am to enter data in a file named IVA. It has some 80-90 columns. Among these, first I am to enter the CODE. When I am entering the code in colA) in this file, it should check:
1) In lists.xls file (in sheet named Admin) whether the ColA is equivalent to the file name of dataentry is being done.
2) If the file name is right, then it should check whether the entered value is there in colB of Admin sheet of lists.xls.
I attached a ZIP file, in which 3 files are there, and explained the requirement.
I hope, someone will come forward to help me to find out the solution.
The help is highly appreciated.
acsishere.
I have some 50-60 files in which data entry is done by individual users. I have a shared workbook (LISTS.XLS) - (sheet named ADMIN) - in which the data already available as follows:
colA / ColB
(Branch) / (Code)
IVA / 5587
IVA / 8788
VC / 6783
VC / 7329
VC / 9283
VB / 2638
IVA / 4792
IVA / 6879
..... ColB consist unique values. There is no repitition.
I have a set of files which are named after the values of the colA of Lists.xls - (i.e. I have files like VB.XLS, IVA.XLS, VC.XLS, and so on).
Now I am to enter data in a file named IVA. It has some 80-90 columns. Among these, first I am to enter the CODE. When I am entering the code in colA) in this file, it should check:
1) In lists.xls file (in sheet named Admin) whether the ColA is equivalent to the file name of dataentry is being done.
2) If the file name is right, then it should check whether the entered value is there in colB of Admin sheet of lists.xls.
I attached a ZIP file, in which 3 files are there, and explained the requirement.
I hope, someone will come forward to help me to find out the solution.
The help is highly appreciated.
acsishere.