Dear All,
Kindly suggest how to start with. i am updating leaves for employees. if
they applied in system no problem, if they not applied i need to apply on
behalf of them.
there wiil be lot leaves to be applied. it was major problem in
consolidating leave data., so i need to automate the process of applying
leave.
Problem description :
1) We take dump from some excel files in one folder,which
will be kept in local server. i need to collate all the excel books in to
one sheet(like master
sheet).
2) based on condition i need to count rows,find duplicates
and eliminate them and arrange in clean format.
3) In master sheet have records(means, each row treated as
one record). i need to distribute those records among 10 associates, based
on
condition.an automatic mail need to be sent to each
associate with distributed list of records.
4) associates process the records and sent those records,
here i need to collate again those files and find the updation of status of
each record
here i need to find.
a) how many records sent to each
associate.
b) how many they processed
c) how many records did they send
back
d) pending records with them
5) if each associate update the records, i need to find the
updation status of each record
here i need to find
a) need to find how many records
received and processed.and sent back to server folder.
Format of Records :
Unique Id Emp id
Date
Type of leave Applied
No of days
status
Remarks
Processed date 1 123
1/1/2008
vacation
1
Appiled EL
NA
2/17/2009 2 234
1/2/2008
SICK
0.5
Already applied
Error
2/18/2009 3 345
1/3/2008
ML
1
Appiled EL
Error
2/19/2009 4 345
1/4/2008
vacation
1
Appiled EL
NA
2/19/2009 5 345
1/5/2008
SICK
1
Already applied
NA
2/19/2009 6 678
1/6/2008
vacation
1
Appiled EL
NA
2/19/2009
Requirement :
A) I don't know how to generate continuous Unique ID to each row(
each record).
B) No idea how to distribute records automatically. example: if
records received is 100 each associate will get 10 records normally ,
but here based on Emp id's , the records need to be separated
in such a way that, like in those 100 records received there might be 20
employees in
that, which means for each Emp ID there will be one or more
records avaliable.
so, distribution should be done based on Emp ID and no
records are distributed in way like , if one EmpI ID has 40 records those
records should not
be distributed normally,i.e 10 records to cach
associate.itshould be distributed as a whole to associates.
C) need to generate reports based on dump recived.
D) tracking need to done i.e ,suppose ,if leaves are already
applied for that day. if we recive the same record again in feature.
I kindly request you, suggest me how can i start automation. i
have little knowledge on macro's and VBA coding. trying to learn now.
waiting for your valuable suggestions.
--
Thanks& Regards,
Mahesh.Pelluri
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
