Macro for Checking Acct No with Acct

A

anurag.d

Hello,
Every month I receive Employee pay data from an agency in Excel.
I have to check whether the account number put by the agency ar
correct or not.
eg:Basic has account number 610300,610200,610250.I have to verify tha
the entire data contains only these account number in the ro
corresponding to Basic.
Similar to "Basic" above their are about 50 more fields with differen
account numbers(number of accounts vary between 1 to 6) for which
have to check the data.
The data is voluminous with the fields appearing randomly.
eg:Basic may appear in the 1st,2nd or nth row multiple times. (an
similarly the other fields)
So in short,
The Macro should look for the word Basic (or any other X field),then i
should look for the corresponding Account Nos.Then it has to chec
whether the account number is correct for that account.
Hope so i have been as elaborate as possible.

Thanks!
 
G

Guest

No. you have not been elaborate as possible.
your statement about the fields appearing randomly
presents a problem. workable but that is an odd report
where standard data appears randomly.
What is "basic"?
How will the macro know what is correnct or not. the macro
will have to compare the acct number to something in order
to know what is correct. do you have a list of correct
acct numbers.
and what is this "any other X field"?
 
A

anurag.d

Ok.
Let me explain again.
1.Basic is a field.In a employees salary their are various component
like Basic,Rent Allowance ,Income Tax,Profession Tax etc.
2.Yes I have a standard list of the account nos which should go wit
the appropriate field.
3.By any other X field I mean as per 1 above.We have almost 5
different components of salary or fields for which I need to check.
eg:
Standard List:
Field Acct Nos
Basic 610300,610200,610250
Income Tax 610000,610010
Rent Allowance 610500,610400,610399,610259
xxxxxx 12121212121212

(Note the acct nos vary for each field)

Data to be checked:
Field Acct No.
Basic 610300(Note that any 1 of th
above
standard lis
appears here)

Basic 610300
Basic 610200
Income Tax 610010
Rent Allowance 610500
Income Tax 610010
Income Tax 610000
Rent Allowance 610300 (The Macro shud catch this entry
since the Acct N
is for Basic
and has been pu
for Rent
Allowance)


Is this possible??
Checking such voluminous info manually every month is making my lif
miserable!!

Thanks
 
Top